Forum Discussion
Schema changes in delta table impacting semantic model and PowerBI reports
- Anonymous2 years ago
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:
- Update the related table info in semantic model
- Check and recreate the relationship if there is any relationship created base on the field of the renamed table
- Update the measure if there is any measure reference the renamed table
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:
- Update the related table info in semantic model
- Check and recreate the relationship if there is any relationship created base on the field of the renamed table
- Update the measure if there is any measure reference the renamed table
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