Trying to embed a PowerBI Report with a URL filter into a SharePoint Webpage

Question

Hello,
We are trying to embed a PowerBI Report with a URL filter into a SharePoint Webpage

We can embed a PowerBI Report into our webpage using the "Modern" look but the URL is not recognized with the filter on the end

We need to attach the filter similar to the following at the end of the URL:
?filter=JCMasterJob/Job eq '11-21-6297'

to filter rows in our SharePoint Webpage.

How do we embed a filtered PowerBI Report into our SharePoint website/webpage?

Thank you

thumbnail image 1 of blog post titled

						Trying to embed a PowerBI Report with a URL filter into a SharePoint Webpage  
						  
					  
				  
		  
	  
  
		  
  
  
  
  
  

Answer 1

@vsslasd

Update：

Sorry for the delay reply.

According to this Microsoft article, when you embed a report web part in SharePoint Online, URL filters aren't supported with the SharePoint Online web part.

---

Power BI is currently not supported in the Q&A forum.

Please start a new discussion via the Power BI Community so that you can get dedicated support on this issue.

Thank you for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thank you for the help -
Is the "script Editor" the same as "Embed" in the Modern Experience of SharePoint ?

I tried what you suggested with "Embed" and I get just a PowerBI Logo, without the report... looks like it's trying to do something, but just the white box with the yellow PBI icon in the middle.

I don't see a "Script Editor" at all

Answer 3

The accepted answer (that isn't possible) isn't accurate at all. As Ali stated it can be done on old version of Sharepoint. And for Sharepoint 365 you can tweak it just a little by using the embed code from the Power BI report (DON'T select Sharepoint, use website) then in the Page Editor in Sharepoint select "Embed" instead of Power BI. Add your filter parameter and it'll load with URL parameters.

Answer 4

Hello,

To embed a Power BI report with a URL filter into a SharePoint webpage, you can follow these steps:

1. Go to the Power BI report that you want to embed and click on the "File" tab.
2. Click on "Embed in SharePoint Online" in the "Publish" section.
3. In the "Embed in SharePoint Online" window, click on "Copy" to copy the embed code.
4. Go to the SharePoint webpage where you want to embed the report and edit the page.
5. Add a "Script Editor" web part to the page.
6. In the "Script Editor" web part, click on "Edit Snippet" and paste the embed code that you copied in step 3.
7. Modify the embed code by adding the URL filter at the end of the "src" attribute, as follows: src="[report URL]&filter=JCMasterJob/Job eq '11-21-6297'"
8. Click on "Insert" to insert the modified embed code and then save the page.

This should embed the filtered Power BI report in your SharePoint webpage. Note that you need to have the appropriate permissions to embed the report in SharePoint and to apply filters to the report.

Good luck!