Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
Currently, I have a Power BI dashboard embedded into a Sharepoint site. I would like to have the dashboard change the data presented based on who is currently viewing the Power BI dashboard on the SharePoint site. An example of this would be if John went to the SharePoint site with the Power BI dashboard embedded into it, the Power BI dashboard would showcase data (coming from a table that for example provides name, email, favorite color and other fields) relating to John specifically. I realize that this is a bit of a combination problem between Power BI and SharePoint, but I figured that it fits in a Power BI dicussion board based on the fact that my problem is basically I want Power BI to take user data from SharePoint and present data based on that user data.
Please first take a look at the Granting Access to reports in the following article:
Embed with report web part in SharePoint Online
Basically,
"
Embedding a report in SharePoint Online does not automatically give users permission to view the report. The permissions to view the report are set within the Power BI service.
Important
Make sure to review who can see the report within the Power BI service and grant access to those not listed.
There are two ways to provide access to the report within the Power BI service. If you are using an Office 365 Group to build your SharePoint Online team site, you list the user as a member of the app workspace within the Power BI service. This will make sure that users can view the contents of that group. For more information, see Create and distribute an app in Power BI.
Alternatively, you can grant users access to your report by doing the following.
Add a tile from the report to a dashboard.
Share the dashboard with the users that need access to the report. For more information, see Share a dashboard with colleagues and others
"
Regards,
Michael
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.