Facing refresh errors on Power BI Service - column does not exist in the row set.

[Anonymous]

Hi,

I am facing a schedule data refresh error on Power BI service in all of my dashboards. 

I am using Azure Blob storage as my data source and the data is coming in on Import Mode. 

When I downloaded the PBI's with errors and then refreshed them on Power BI desktop, they got refreshed in one go.

Also when I republished these reports on Service and refreshed them, they got refreshed easily.

I am not able to understand what is the underlying issue, why PBI Service is showing an error while processing the dataset.

[v-xiaotang · Accepted solution]

Hi @Anonymous 

(1) Download the .pbix file,

(2) go to Power Query Editor, remove column1 in Advanced Editor,

(3) then republish the .pbix file.

Here is the tutorial, take a try,  Refresh error: The xxxx column does not exist in the rowset

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

No the credentials are fine

[arvindsingh802]

This seems to be access issue, make sure you are using same credentails as in Power BI desktop and on Power BI web