Forum Discussion
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: ...
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
Thank you!
If you create an embed code with that report, do you need to create a new code every time you republish that report?
- aj1973
Community Champion
What do you mean by Embed code with that report?
As I said any change done in the desktop, needs to be published to the service in order to update the dataset. Unless you Edit the report directly in the service.