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.
Hi Anonymous,
Thank you for reaching out to Microsoft Fabric Community Forum.
If there is a poosibility, Switch to DirectQuery Mode If UDFs are frequently changing and it's challenging to predict which columns might be added, switching to DirectQuery mode could be beneficial.
With DirectQuery, queries are executed in real-time, you don't need to pre-define columns in Power BI. The data is retrieved directly from the source during runtime, adapting to any changes in the schema without requiring adjustments to the model.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hi Anonymous , Thanks for the response.
We can't go with direct query mode, since data won't change that frequent even columns too.
Moreover we incorporated complex YTD and to date DAX measures in the file which will under perform with Direct query mode.Please suggest if you have any other options too...
Hi Anonymous,
Manually refresh the schema in Power BI Desktop when columns change, update transformations as needed, verify the dataset, and re-publish it to Power BI Service.
Regards,
Vinay pabbu
Hi Anonymous,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Vinay Pabbu