Forum Discussion

prantika's avatar
prantika
Regular Visitor
2 years ago
Solved

Schema changes in delta table impacting semantic model and PowerBI reports

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 i...
  • Anonymous's avatar
    Anonymous
    2 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