Forum Discussion
Post ProdigySPO refresh errors started yesterday? <pii>OData__ExtendedDescription</pii>
We updated the data gateway and then deleted all the saved credentials in the files.
Re-entered them and set all the privacy levels to ORGANIZATIONALY and redeployed, that helped with most of it.
Hi
We are experiencing the same issue that started on 15/04/22. No changes made to the dataset. Seems to work fine in Power BI desktop, but not once its published to the workspace.
Hi jjdev ,
Please refer to the topic to see if it helps you.
The '<pii>ColumnName</pii>' column does not exist in the rowset.
Possible solutions:
1) Personaly would unpivot "other columns" and rebuild data model around that.
2) You could rename columns by position to Month -5, Month -4 etc (don't know how many you have!)
3) You could update model using tabular editor connexted to xlma end point. It has scripting ability.
3) There's some stuff on programmatically updating a model via xlma end point in C# https://www.sqlservercentral.com/blogs/power-bi-meets-programmability-tom-xmla-and-c
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.