Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data source error The column 'XXX' does not exist in the rowset - weirdest bug?

Hi folks,   I just had the weirdest bug that took me some time to figure out. I uploaded a PowerBI report to the cloud and everytime the data was to be refreshed, I would get the infamous error "Da...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks for posting additional information here. I know about these types of "problems" when referencing a column by name in m script / PowerQuery but in my specific case this was not the issue.

     

    As I wrote in my original post, the issue was literally that I didn't refresh the report in the report editor before uploading it and after I did, everything was fine. You can check this when you view the model and the "old" columns are still visibile (I never tried to uploading without replacing though, but I doubt this would have solved anything).

     

    Again, thanks for putting more references here. However, my issue was a different one for which I didn't find a solution documented anywhere so I posted it.