Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 ?
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.
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.
Yeah, but the thing is you don't have to use PBI Embedded for your viewers to not need a license. PBI Premium alone will do this, that's what most orgs doo. PBI Embedded is usually what you use if you want people without a login to your M365 environment (e.g. external users) to view reports.
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.
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