Forum Discussion
Refresh error using OneDrive Personal
So I have csv files that are in one drive I have them connected but have an error when refreshing. It tells me that a column is missing in the file. How do I correct the error? It seems like there is a formatting error that I cannot figure out. Ignore the product catregory error it went away.
HI 330SMG ,
Here was my solution to the same problem: Download the Report from Report Server and open in PBI Desktop. Click on 'Edit Queries' to get to the 'Power Query Editor'. For the suspected table in question (this might be trial and error on all tables), click on the 'Source' for the 'Applied Steps'. Find the source table/view in the list and click on the link in the 'Data' column. Power BI will tell you that you're about to create a navigation step - click Continue (as long as your existing navigation step hasn't been previously modified). Refresh all queries and apply changes to the report and refresh the data in the report etc. Save and re-upload to Report Server (don't forget to use 'Replace' to keep existing usage history). Hey presto! You might need to repeat for all tables you have in your report.
Refer:
https://community.powerbi.com/t5/Service/The-column-does-not-exist-in-the-rowset/m-p/327629
Best RegardsLucien
3 Replies
330SMG , In the factinternationsales the column Order year is missing chack that. Remove that column from rename or other steps
Quite confusing and unclear answer, Order year is not in the table or the csv file. Is it because it is a sub data list in the table breaking down the year?
HI 330SMG ,
Here was my solution to the same problem: Download the Report from Report Server and open in PBI Desktop. Click on 'Edit Queries' to get to the 'Power Query Editor'. For the suspected table in question (this might be trial and error on all tables), click on the 'Source' for the 'Applied Steps'. Find the source table/view in the list and click on the link in the 'Data' column. Power BI will tell you that you're about to create a navigation step - click Continue (as long as your existing navigation step hasn't been previously modified). Refresh all queries and apply changes to the report and refresh the data in the report etc. Save and re-upload to Report Server (don't forget to use 'Replace' to keep existing usage history). Hey presto! You might need to repeat for all tables you have in your report.
Refer:
https://community.powerbi.com/t5/Service/The-column-does-not-exist-in-the-rowset/m-p/327629
Best RegardsLucien
