Power BI dataset refresh error when Excel column is deleted

[lmelero]

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:

Underlying error code: -2147467259
Underlying error message: The column '12 Hr Range' of the table wasn't found.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: 12 Hr Range
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-US-GOV-VIRGINIA-redirect.analysis.usgovcloudapi.net
Activity ID: 80d9d46b-5db0-4418-b9e8-faede7b293db
Request ID: 7779293c-c25d-7dd2-fb28-6cde59b1ab76
Time: 2021-07-27 14:24:57Z

Do I have to republish my entire report in order to fix this issue?   Thanks for any help!

[lmelero]

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]

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.

[lmelero]

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

[lmelero]

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.  

[aj1973]

I also was thinking about something similar or close to this (using parameters) 

https://www.youtube.com/watch?v=iiNDq2VrZPY

https://www.youtube.com/watch?v=OnaDJkGOmIE&t=83s

I don't know, it might help

[aj1973 · Accepted solution]

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