Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have a PowerBI Pro liscense working in a Premium Capacity workspace. I built the workspace by upload to .pbix files I built in PowerBI Desktop. There are 2 reports that I want to embed into a SharePoint site. So, my premium workspace has 6 items: a report, a dashboard, and a dataset for each.
Now, I created an App for this workspace and chose the Share to Entire Org option. The install automatically option is not-clickable in this case for me. To embed to SharePoint, I am going into the App, hitting the Share option for each report > Embed to Sharepoint, and using that link. When I go to SharePoint, I can see the report just fine. However, when end users going to the SharePoint, it says "You do not have access". Users can however, hit request access and go get the App for our organizational AppSource. I WANT TO ELMINATE THE APPSOURCE STEP. I want users to just be able to see the report on SharePoint. I have followed all the documentation to the word, and I still cannot get this to work. When I look at 'manage permissions' for the Datasets, it says 'entire org'. However, if I click to the report, it does not have that, but there is no option to add it other than the main App create! Essentially, Entire Org permissions only show up for the datasets in the App.
What am I doing wrong here? It is driving me crazy, I do not see an option to add the org to the reports other than the app create.
Solved! Go to Solution.
Hi @samdean332 ,
There are two common reasons for this message.
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. For more information, see how to manage a workspace.
The second way is to embed a report within an app and share it directly with users:
The author, who must be a Pro user, creates a report in a workspace. To share with Power BI free users, the workspace needs to be set as a Premium workspace.
The author publishes the app and installs it. The author must install the app so it has access to the report URL that is used for embedding in SharePoint Online.
Now all end users need to install the app too. You can also use the Install app automatically feature, which you can enable in the Power BI admin portal, to have the app pre-installed for end users.
The author opens the app and goes to the report.
The author copies the embed report URL from the report the app installed. Don't use the original report URL from the workspace.
Create a new team site in SharePoint Online.
Add the previously-copied report URL to the Power BI web part.
Add all end users and/or groups who are going to consume the data on the SharePoint Online page and in the Power BI app you created.
Note
Users or groups need access to both the SharePoint Online page and the report in the Power BI app to see the report on the SharePoint page.
Now the end user can go to the team site in SharePoint Online and view the reports on the page.
Reference: Grant access to reports
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @samdean332 ,
There are two common reasons for this message.
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. For more information, see how to manage a workspace.
The second way is to embed a report within an app and share it directly with users:
The author, who must be a Pro user, creates a report in a workspace. To share with Power BI free users, the workspace needs to be set as a Premium workspace.
The author publishes the app and installs it. The author must install the app so it has access to the report URL that is used for embedding in SharePoint Online.
Now all end users need to install the app too. You can also use the Install app automatically feature, which you can enable in the Power BI admin portal, to have the app pre-installed for end users.
The author opens the app and goes to the report.
The author copies the embed report URL from the report the app installed. Don't use the original report URL from the workspace.
Create a new team site in SharePoint Online.
Add the previously-copied report URL to the Power BI web part.
Add all end users and/or groups who are going to consume the data on the SharePoint Online page and in the Power BI app you created.
Note
Users or groups need access to both the SharePoint Online page and the report in the Power BI app to see the report on the SharePoint page.
Now the end user can go to the team site in SharePoint Online and view the reports on the page.
Reference: Grant access to reports
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
96 | |
46 | |
26 | |
21 | |
19 |