Forum Discussion

GJA's avatar
GJA
Helper II
2 years ago

Automatically create a sharepoint page embedding power bi report

Hi, 

 

in my organization we use sharepoint to share power bi reports with users. 

 

It means that for each new published report we need to create a new sharepoint page embedding the report.

 

Does anyone has an idea on how we can automate the creation and publication of the sharepoint page ? I thought to use power automate but I don't know it the entire process is feasible.

 

Many thanks

Need Help

6 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    2 years ago

    Hi GJA 

     

    I'm personally not aware of such a Automate process. 

     

    Without knowing the reasons why your company embeds reports in SharePoint, I would ask this question of them

     

    Since the End User needs at least a Power BI Pro Account to view a report, why not create an App within a workspace in Power BI service that hosts all the reports? They are quite flexible on who can see which report. More info here https://learn.microsoft.com/en-us/power-bi/consumer/end-user-apps

     

    Thanks

    Joe

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    You might be able to do this with Power Automate Desktop (not cloud), but it sounds like you should be using a Power BI app instead and linking to the app from SharePoint. Apps are designed to be the navigation experience for reports in a workspace. 

  • GJA's avatar
    GJA
    Helper II
    2 years ago

    Hi, 

     

    thanks for the replies. We want to share reports with sharepoint because we have a premium embedded licence. I think to share the pbi app users must have a pro licence ?

    • christinepayton's avatar
      christinepayton
      Most Valuable Professional
      2 years ago

      SharePoint does not factor into Power BI licensing in any regard, they are independent. You can interact with PBI premium without going through SharePoint at all. 

      • GJA's avatar
        GJA
        Helper II
        2 years ago

        Hi, 

         

        I think I misunderstand : 

         

        We have workspaces with premium embedded licence 

        So we need to embed the reports in websites to share with users. If the report is shared using a website it can be read by a users who do not have a licence. If we directly share the report by app.powerbi.com the users can't read the report. That's why we use sharepoint to create pages and embed the reports.

         

        May be there is a better way to share the reports ? With the power bi applications there is almost no customization for the navigation through pages.