Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

pii column does not exist in the rowset

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
Comments
chiragppatel
Microsoft Employee

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

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.