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 , 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 PabbuHi Anonymous,
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
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,
Please share the solution here, It would really help other community members who face similar issues to solve them faster.
Regards,
Vinay Pabbu