Forum Discussion
The column does not exist in the rowset
Thanks @v-shex-msf.
After stabbing buttons in the desktop app, I managed to refresh the query and republish the report. I was then a little panicked to see that thee of the four charts in the report were showing as in error. I traced this to a custom field in the report which identifies the creation month from the creation date. (It made sense that this field had been dropped, as it is not in the original data set.) Once I'd added this back in to each chart, the report functions correctly again.
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.
Thanks! Worked for me.
The Table View is
Search for your Table (that has column missing) in here
Refresh the data from your selected table (use the thre dots)
- Save
- Publish and Replace
- Fixed my Autorefresh.