Forum Discussion

Mupps's avatar
Mupps
Regular Visitor
8 years ago
Solved

The column does not exist in the rowset

Bit of a Newbie... I'm using PowerBI with a SharePoint List.  The Report has been wokring fine for a while until I deleted a redundant column from the SharePoint List.  Now I get the error "The <del...
  • Mupps's avatar
    Mupps
    8 years ago

    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.

Mupps's avatar
Mupps
Regular Visitor
8 years ago

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.