Schema update on desktop is not updated on service after it is published

[jerish]

I have a PBI report using live connection to a tabular database which is published and all works fine.

Now after renaming a column (let's say COLA to COLB) in tabular db the column name is correctly updated on the PBI desktop after a deploy and refresh. On the desktop, the report is also modified to use the new column COLB.

Now is the problem, once this report is published to the PBI service, the message confirmed the dataset is replaced but the change is not getting updated in the workspace. The dataset still have the old schema with the old renamed column COLA  still there and no COLB. The report is also failing complaining about COLA not available. I tried refresh of the dataset from PBI service and it still not working. I waited few hours and still no luck. Now I am stuck and any help is appreciated...

[jerish · Accepted solution]

Gilbert, the service got updated overnight. Thank you for your response

[GilbertQ]

What happens if you download the PBIX from the Service and then connect, does it work correctly?

[jerish · Accepted solution]

Gilbert, the service got updated overnight. Thank you for your response

[GilbertQ · Accepted solution]

Awesome, this was not via publish to web report?

[jerish]

Yes. It was a publish to the web but it took a long time on the web to get the schema update. Even after deleting the report and dataset from the web and re publishing multiple times the column name was not updating until I checked overnight.

[GilbertQ]

Hi there,

They do cache the data on the Power BI Service when using the Publish to Web so it can take some time to get updated.

[jerish]

I checked this morning and they are updated. Almost 12 hours to refresh???