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 reports built directly from SharePoint lists. Since these reports cannot be downloaded as .pbix files, what is the easiest way to migrate them to Power BI Desktop without rebuilding everything from scratch? Any guidance would be greatly appreciated.
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.

9 Replies

  • 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 

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

      Hi NHariGouthami 

      Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

      • NHariGouthami's avatar
        NHariGouthami
        Microsoft Employee
        8 months ago

        Yes I did but still this not solved the problem of creating reports without rebuilding in this case.

    • 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.