Fix Power Bi column errors with these quick solutions

Tashreef Shareef
by Tashreef Shareef
Windows & Software Expert
Tashreef Shareef is a software developer turned tech writer. He discovered his interest in technology after reading a tech magazine accidentally. Now he writes about everything tech from Windows to iOS and streaming services... Read more
Affiliate Disclosure
Power bi error sort by another column
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

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.


This article covers:Topics: