Fix Power Bi column errors with these quick solutions

3 minute read
Power bi error sort by another column

Home » Fix » Fix Power Bi column errors with these quick solutions

While using the Power Bi desktop app you may face some issues with your data and file. One such error is related to Power Bi columns. Some of the most common Power Bi column errors include ” power bi can’t find column, power bi error sort by another column and power bi error column not found” as reported by several users in the Power Bi community forums.

I have categories that I want to sort. The data looks like this:To populate the sort order column, I wrote the following formula:
Then, I tried to use the “Sort by Column” tool to sort the Category column by the Sort Order column, but the following error message occured:

In this article, we have compiled a list of possible solutions to fix Power Bi columns error in Windows 10.

How to Fix Power Bi column errors

1. Power Bi can’t find column

Power Bi can't find column

Check the Formula 

  1. If you are using DAX formulas for the column, you may want to review the formula again. Try the following.
  2. First, create a calculated column using the appropriate measures.  If it works fine with the expected result, try to create a measure using the same formula.
  3. If the error is showing, add Values () function and check again.
  4. This should help you resolve Power Bi can’t find column error.

Add aggregate Function

  1. If the columns don’t come up when you click on New Measures, this is due to a missing aggregate function.
  2. To get a column into a measure you need to apply an aggregate function to a column or call on another calculated measure.
  3. Apply the recommended changes and check if the error is resolved.

Can I use Power Bi for free? We answer!


2. Power bi error sort by another column

Sort by Index Column

  1. You can try to fix sort by another column error with simple tweaks like this.
  2. Add an index in the Query Editor. So click on Edit Queries > Add Column and select Index Column.
    Power bi error sort by another column
  3. Click on Sort by Column and select Index.
  4. Check if the sort by another column error occurs again.

3.  Power Bi error column not found

Power Bi error column not found

Clear Data Source Cache 

  1. The power bi error column not found error can occur if the data source cache is corrupted. You can easily fix this by clearing data source cache in Power Bi.
  2. In Power Bi client, go to Data Source Settings.
  3. Now clear all permissions.
  4. Recapture the permission again.
  5. Try to load the source again and try to make the necessary changes.

Check for Extra Column or Space

  1. This error can also occur if the Excel file has column1 (extra column) or for extra space after column1.
  2. It is possible that when you use Excel file as a source, you may get additional null columns.
  3. To prevent his you can use Remove Other Columns option to keep the columns you want instead of tinkering with unwanted columns.

RELATED STORIES YOU MAY LIKE:

Discussions

Next up

Troubles with your Uplay login? Here’s what you can do

John Taylor avatar. By: John Taylor
2 minute read

Some users have reported that they are having problems when trying to log in their Uplay client. Apparently, they receive an error message that looks […]

Continue Reading

Scroll bar is missing in Chrome on Windows 10 [FIX]

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

Google Chrome is the most popular browser out there. It is a reliable tool to surf the Internet and has many great features. However, nothing […]

Continue Reading

What to do when your Uplay achievements are not syncing

John Taylor avatar. By: John Taylor
2 minute read

Uplay is an amazing game distribution platform created by Ubisoft. It can be used to buy and download games as well as DLCs. It can […]

Continue Reading