Forum Discussion

arock-well's avatar
arock-well
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

SharePoint List Report Won't Load in Workspace App

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...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    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

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
1 year ago

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's avatar
arock-well
Icon for Responsive Resident rankResponsive Resident
1 year ago

"...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.