Automating Power BI Report Migration from On-Prem ODS to Microsoft Fabric Gold Layer (Medallion Architecture)

Hi everyone, We’re in the middle of a major migration and I’m looking for advice on how to automate as much as possible. Current Situation • We have many Power BI reports pointing to an on-premise ODS. • The semantic models contain quite a bit of SQL logic (especially for dimension and fact tables). • We’re using a Medallion architecture in Microsoft Fabric: Bronze (landing), Silver (cleaning), and Gold (star schema / snowflake with conformed dimensions and facts). Goal Move the transformation logic upstream into the Gold layer and repoint the Power BI semantic models to the new Gold tables in