Forum Discussion
Embed Power BI report into SharePoint Online - Web part options not working
Thanks Bosko
Unfortunately for me that didn't help, however I did find a different solution (the PowerBI/Sharepoint integration seems quite buggy). Here is what I did:
1. Click edit your sharepoint page
2. Add a second Powerbi report web part which is a duplicate of the one you want to adjust the options to hide the navigation or filter panes. This duplicate you will also need to paste in the report link so that it is a working duplicate.
3. Click save draft for the Sharepoint page.
4. Click edit sharepoint page again
5. Click on your duplicate PowerBI web part and open up the edit pane for it. But dont click any options.
6. Next click on the original PowerBI report that you actually want to edit (the edit pane with options remains open). You will find you can now turn off the navigation pane or filter options for the original PowerBI web part!
7. Click save your sharepoint page as draft. You might find the duplicate has disappeared (very buggy I know!). Or if duplicate has not dissappeared, then just click edit your page again and delete the duplicate without touching your original.
Good luck, this is a little crazy but it seemed to work.
I think I found a work around to this. When the options appear on the right, I paste the embed address into the “Power BI report link”. Then I click repeatedly on the other options (like Display) as the page is refreshing and saving the draft. After the page finishes the refresh and saves while I am clicking, the options are now available to be selected and changed for the Power BI web part. This work around appears to work 100% of the time for me.