Forum Discussion

NHariGouthami's avatar
NHariGouthami
Microsoft Employee
9 months ago
Solved

How to Migrate SharePoint-Integrated Power BI Reports After Deprecation Without Rebuilding?

With the deprecation of SharePoint–Power BI integration (Deprecation of Power BI Integration within SharePoint Lists and Libraries | Microsoft Power BI Blog | Microsoft Power BI) , we have several re...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    8 months ago

    Hi NHariGouthami 

    Thanks for the update. Since the workspace is managed externally, only the Workspace Admin has the ability to grant the required permissions. From our side, we don’t have visibility into the workspace ownership or the authority to modify access.

     

    Kindly reach out to the Workspace Admin of MDEE Org Power BI to request Contributor (or above) permissions.

amitchandak's avatar
amitchandak
Super User
9 months ago

NHariGouthami , We have now got the edit model in Power bi in Web. Just see if you can download the Power Query part from there, and then you can just match the base DAX table and column name, the rest can be migrated using ALM toolkit

Second, we have the Semantic Link Lab library which will again create code for Dataflow Gen 2 landing to lakehouse 
https://github.com/microsoft/semantic-link-labs

With both cases, you should be able to get the Power Query code, which you change to suit the new connector, and use the ALM toolkit or Power BI/Fabric rest API to migrate measures 

NHariGouthami's avatar
NHariGouthami
Microsoft Employee
8 months ago

Thanks amitchandak for the repsonse. But i dont see option to download the power query part even in the edit mode.

 

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    8 months ago

    Hi  NHariGouthami ,
    Thanks for confirming and for the additional details. Since you’re not seeing the “Download this file” option on your end, it may be related to the permission configuration for your access.

     

    Could you please cross check :

    • Your workspace role (Admin, Member, or Contributor are required for PBIX download)

    • Whether you have Build permission on the dataset.


    From our end we can able to see the option in edit mode, attached screenshot as below :

     

    Hope this helps !!

    Thank You.

     

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      8 months ago

      Hi NHariGouthami 

      Could you please provide an update once you have checked the above items?
      If the issue still persists after verifying these permissions, please let me know so we can proceed with the next troubleshooting steps.