cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jerish Regular Visitor
Regular Visitor

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

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...

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
jerish Regular Visitor
Regular Visitor

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

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

Super User
Super User

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

Awesome, this was not via publish to web report?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
6 REPLIES 6
Super User
Super User

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

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

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
jerish Regular Visitor
Regular Visitor

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

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

Highlighted
jerish Regular Visitor
Regular Visitor

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

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

Super User
Super User

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

Awesome, this was not via publish to web report?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
jerish Regular Visitor
Regular Visitor

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

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.

Super User
Super User

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

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.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"