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...
Solved! Go to Solution.
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.