Forum Discussion

lmelero's avatar
lmelero
New Member
5 years ago
Solved

Power BI dataset refresh error when Excel column is deleted

I'm using Excel spreadsheets as datasources and deleted a column in one of the spreadsheets.  I was able to refresh in Power BI desktop but when I try to refresh in the service I get this error:   ...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi lmelero 

    The answer is Yes. To say it in an easy way, the Dataset in the service doesn't know about the change in the source therefore by republishing the report you will update the Dataset.

    Basicly Whenever you make a change in the desktop you need to republish it to take effect in the service 

lmelero's avatar
lmelero
New Member
5 years ago

I'm using an embed code in order to share the report on a website.

lmelero's avatar
lmelero
New Member
5 years ago

I think I may be able to keep the same embed code if I just replace the report with the updated report instead of deleting, I'll have to test it though.