Forum Discussion

Ramkishor's avatar
Ramkishor
Icon for Helper II rankHelper II
10 months ago
Solved

How to migrate SQL views, and Power BI reports from UAT to Production?

Hi everyone, I developed several Power BI reports in a Microsoft Fabric for D365 F&o UAT environment. These reports use a Lakehouse as the data source. Inside the Lakehouse SQL endpoint, I created...
  • amitchandak's avatar
    amitchandak
    10 months ago

    Ramkishor , In case of Microsoft Fabric, you should not create a view in SQL endpoint, it will lead to Direct Query not Direct Lake. 
    The way you should to is 

    Make sure all columns, and Rename is done till the lakehouse level, whatever is possible 
    Create a Reporting Lakehouse in Reporting Workspace 
    Create shortcut from all other lakehouses to this 
    Create a semantic Model using this Lakehouse(Option in Lakehouse UI) and rename and measure creation in Semantic Model  

    Refer MS  Fabric - Power BI Direct Lake Semantic Models
    https://youtube.com/live/1HDxJASdSws

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
10 months ago

Hi Ramkishor,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

 

 

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support