How to pass parameter to my POWERBI embedded report?

Question

I have an IFrame which shows a PowerBI embedded Report that shows a list of Accounts.

I want to pass in an Account ID so that I only see the sales for my Account.

In side the report I have a Table lets say in called Query1 and Inside that table I have a field called AccountID. I need to add to my URL to filter the Accountid = 123.

My URL is something like this.... https://app.powerbi.com/reportEmbed?reportId=xxxxxxxxxxxx&autoAuth=true&ctid=xxxxxxxxxxx-xxxxxxxxx&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXdlc3QtZXVyb3BlLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9

What exactly should I add to filter the report by the AccountID?

Answer 1

You should add url parameter called filter. You need to specify table and field you want to filter and add value of the filter after eq. So your end result should be something like that:

URL?filter=Table/Accountid eq 123.

Here's Microsoft documentation about it https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#query-string-parameter-syntax-for-filtering

Update top part of course works for filtering reports in the appor work space itself. To filter embedded report you need to specify the page and filter in a similar fashion for the embedded link https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure. So you link will be something like that:

https://app.powerbi.com/reportEmbed?blabla&pageName=Page1&$filter=Table/Accountid eq 123

Here how it would like once embedded: