Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

michaelsh

pii column does not exist in the rowset

Submitted by Kudo Kingpin on ‎10-16-2021 09:24 AM

My dataset has being refreshing in the service fine for two months. Since earlier today I have this error:

The '<pii>SOME_COLUMN_NAME</pii>' column does not exist in the rowset.

When I refresh the same dataset in the desctop - everything is refreshing fine.

After I upload the refreshed dataset to the service and refresh it there again - it refreshed fine.

I didn't change anything in the desktop, neither I got any power query error.

I also cannot tell whether the column disappeared from the dataset or not, because I have several tables with columns with this name.

But even if a column dissapeared from the raw datasource (ODBC), it is not actively addressed in any step in the power query.

 

Status: Investigating
See more ideas labeled with:
12 Comments (12 New)
Comments
chiragppatel
Employee
Employee
‎06-23-2022 09:46 PM

I do not see this option. refer below screenshot. Let me know where I am missing. What level of permission I need to see this option?

 

chiragppatel_0-1656045968720.png

 

 

 

Anonymous
Not applicable
‎08-12-2022 05:17 AM

Has anyone found a solution for this problem now? It all works fine on Power BI Desktop but I get the error message '<pii>SOME_COLUMN_NAME</pii>' column does not exist in the rowset on app.powerbi.com. 

Thanks for any support. 

 

Idea Statuses