Power BI report / dashboard in sharepoint

[PowerRon]

Hi community

a question.

We have a lot of big fact tables in our DWH in Azure SQL DB. in the end they all will be modelled in a decent Power BI model to be used by the end-user in a report to explore and analyze.

We have multiple end-user groups and one central landing page in sharepoint. Through this landing page the end-user can access their workspace / app. This landing page also gives some global information overall.

On this landing page we want to show some quick insights of the available fact tables. Really on a high level, less detailed then what is offered to the end-user in their own workspace / app.
And we want to generate this information quickly (we only just start, not all fact tables are modelled) to make the end-user curious and longing for more insights.

We talk about payment transactions per month per kind, contracts per months, saving transactions per month per kind etc. 
Only information about last 12 months.

Would you build small aggregates on these fact tables and combine them in one Power BI dataset?
Or would you create a separate Power BI dataset for each small aggregate?
Or would you keep it simple for this, build an aggregated view on top of each needed fact table and use that as Direct Query input for the report?
Can I embed a Power BI report in sharepoint?

Can I embed a Power BI dashboard in sharepoint?

regards
Ron

[v-zhangti · Accepted solution]

Hi, @PowerRon 

With the Power BI report web part for SharePoint Online, you can easily embed interactive Power BI reports in SharePoint Online pages.

For Embed in SharePoint Online reports to work, the following is required:

• A Power BI Pro or Premium Per User (PPU) license or a Power BI Premium capacity (EM or P SKU) with a Power BI license.
• The Power BI web part for SharePoint Online requires Modern Pages.
• To consume an embedded report, users must sign in to Power BI service to activate their Power BI license.

To embed your report into SharePoint Online, you need to get the report URL and use it with SharePoint Online's Power BI web part.

Embedding a report in SharePoint Online doesn't automatically give users permission to view the report - you need to set view permissions in Power BI. There are two ways to provide report access in Power BI. The first way, if you're using a Microsoft 365 Group to build your SharePoint Online team site, is to list the user as a member of the workspace within the Power BI service and the SharePoint page. The second way is to embed a report within an app and share it directly with users.

Currently, only interactive Power BI reports are supported on SharePoint Online pages, and embedded dashboards are not supported at this time.

For more detailed steps, please check the link.

https://docs.microsoft.com/power-bi/collaborate-share/service-embed-report-spo 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.