Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
Expand all | Collapse all

Embedding a report in sharepoint online

  • 1.  Embedding a report in sharepoint online

    Top Contributor
    Posted Feb 25, 2021 08:54 AM
    I am using the power bi webpart to embed a report in sharepoint online which works fine, but it doesn't "remember" my slicer settings if I close the browser (or tab) and go back. Is this the expected behavior in power bi within sharepoint or is there another setting I need to check? When I look at the report in power bi service, it remembers my slicer settings just fine, so I know the power bi file itself is fine.

    Thanks!

    ------------------------------
    Sam Duval
    Data Quality Analyst
    Element Financial
    Indianapolis IN
    ------------------------------


  • 2.  RE: Embedding a report in sharepoint online

    Gold Contributor
    Posted Feb 26, 2021 02:09 AM
    Hello Sam,

    I am not a Power Bi expert but if you try to use not the power bi webpart but a script editor and put the report url in an iframe does it works better ?
    Also maybe you should post this message on the power bi user group.

    Best regards,

    ------------------------------
    Alaa Bitar
    Consultant
    Serial Sa
    ------------------------------



  • 3.  RE: Embedding a report in sharepoint online

    Top Contributor
    Posted Feb 26, 2021 07:03 AM
    Thanks @alaah I tried the iframe first but it w wasn't rendering very well because my options were limited as to turning off certain things like navigation and the filters pane.

    I didn't realize that I had posted this to the automate group, to many power something's. I'll post this over in the pbi group and follow up if they have a resolution​​

    ------------------------------
    Sam Duval
    Data Quality Analyst
    Element Financial
    Indianapolis IN
    ------------------------------



  • 4.  RE: Embedding a report in sharepoint online

    Silver Contributor
    Posted Mar 01, 2021 10:04 AM
    Yes this this is the expected behavior. When you embed content in SharePoint, think of it as a window or tunnel into that content. SharePoint opens a little portal in the space-time contiuum that let's you work with Power BI, but it doesn't actually control or remember anything. When you reload the page, you reload the content with it's default settings, layout, slicers, etc. The same thing is true for embedded Excel or PowerPoints.

    It works differently in Power BI because in that case you are working WITHIN the proper application. Same way Excel and PowerPoint will remember any changes you make WITHIN the app.

    If you want different defaults, you will need to republish the app in Power BI.

    ------------------------------
    Rachel Davis
    Program Manager, Business Operations
    Rockwell Automation
    ------------------------------