Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
We have a use case which comprises renaming fields in the existing delta tables. These tables are ingested through Direct Lake connection in semantic model and utilized for creating PowerBI reports in Fabric.
We tried renaming one of the table, which caused to break existing relationships with the tables and add the renamed table as a new table. This is affecting our PowerBI reports that uses DAX measures.
What is the optimized method to perform schema changes in tables, which does not break the DAX measures and existing relationships created in the semantic model? Is there any way to replace tables in semantic model that allows us to map field between these tables post schema changes?
Thanks!
Solved! Go to Solution.
Hi @prantika ,
According to your description, it seems that the table was renamed of delta tables. When making schema changes to delta tables that are used in a semantic model and PowerBI reports, it's important to consider the impact on existing relationships and DAX measures. Please update the following info in Power BI:
And you can refer the following link for optimizing schema changes in Delta tables:
Delta Lake table optimization and V-Order - Microsoft Fabric | Microsoft Learn
Best Regards
Hi @prantika ,
According to your description, it seems that the table was renamed of delta tables. When making schema changes to delta tables that are used in a semantic model and PowerBI reports, it's important to consider the impact on existing relationships and DAX measures. Please update the following info in Power BI:
And you can refer the following link for optimizing schema changes in Delta tables:
Delta Lake table optimization and V-Order - Microsoft Fabric | Microsoft Learn
Best Regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
14 | |
4 | |
3 | |
3 | |
2 |