SharePoint List Report Won't Load in Workspace App

[arock-well]

I have a user who created a Power BI Report using the "Visualize the List" option for a SharePoint list. The report does work when inside the SP List page.

However, when I take the link to use it within a Workspace App, it only shows the Power BI icon in the report and will not load. There are no error messages other than the "!" in the upper left hand corner as it's loading.

I use the "Add a link" option and used it when in the "Edit link" screen.

Not sure what to do with this one and any ideas would be great.

[v-achippa · Accepted solution]

Hi @arock-well,

Thank you for reaching out to Microsoft Fabric Community.

Reports created using "Visualize the List" in SharePoint are not standard Power BI reports and are designed to work only within SharePoint. Power BI Workspace Apps only support reports that exist within a workspace, external links to SharePoint-based visualizations will not load properly.

So convert the SharePoint-generated report into a full Power BI report and publish it properly. Please follow below steps:

• Open your SharePoint List, click on Export and Select Export to Power BI (pbix). This will generate a power bi (.pbix) file that can be edited in power bi desktop.
• Open the exported .pbix file in power bi desktop and modify the report as needed. Now Publish it to power bi service and choose the same workspace where your power bi app is hosted.
• In power bi service, open the published report. click on File --> Embed Report --> Copy Report Link.
• Now in the Power BI Workspace App, go to Add Content --> Add a Link, paste the Power BI Service report link instead of the SharePoint-generated link.
• Save and update the app.

The report will now load correctly inside the Power BI Workspace App because it is properly stored in a Power BI workspace.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @arock-well,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[ibarrau]

Hi. I'm not sure what is exactly that you are doing. It looks like adding a report link in a tile or section app. You can't do that. The "i" is specifying that adding the link there won't work. If you want a report to be part of a power bi app, then you need to keep the report in the workspace you are using to create de App. You can't add reports from a workspace to another App Workspace. Can you define the requirement so we can help you move forward with a solution? maybe what you want is possible but not in the way you are showing here.

I hope that helps,

[arock-well]

"...I'm not sure what is exactly that you are doing..."

I'm copying the link of a Power BI report a user created within a SharePoint list via the "Visualize the List" option and then trying to use that within a Workspace App for users to view.