Forum Discussion

330SMG's avatar
330SMG
Frequent Visitor
4 years ago
Solved

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...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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 Regards

    Lucien

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

330SMG , In the factinternationsales the column Order year is missing chack that. Remove that column from rename or other steps

330SMG's avatar
330SMG
Frequent Visitor
4 years ago

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?