Forum Discussion
Handling Schema Changes in Import Mode – Dynamic Columns in Power BI Service
Hi Anonymous ,
We found a feasible workaround to handle the schema update issue using XMLA endpoint with C#(.NET).
The implementation is in progress.
Thank you.
Alright, let's talk new alternatives. If UDF scenario brings the whole universe of columns and data, then the best approach is getting that data to the semantic model. Then you can use OLS to prevent users of viewing some columns.
https://learn.microsoft.com/en-us/fabric/security/service-admin-object-level-security?tabs=table
As an alternative if you only have two sets of columns possibles, you could build two semantic models. This approach works but you have rework each time you want to do some operations to the table.
Coming back to the power query code. Try pick up a table from the UI when connecting to source instead of a query. Then make sure there is no further steps using columns names. The engine by default adds Change Types step each time you try a getting data step. Changing types always talks about specific columns in the code.
I hope that helps,
ibarrau I should think about OLS option but we already use RLS, which can be considerable point.
But main point is that we are unaware of the new columns count and their names and at which point they gonna added to database also now known earlier.
Reg. alternate option of each time changing in desktop and republishing won't work in our case. Since we wanted to automate the whole process through pipelines.