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