How to pass parameter to my POWERBI embedded report

Question

0

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 need add a filter url argument. You must first define the table and field you want to filter, then add the filter's value following eq. As a consequence, your final product should look like this:

URL?filter=Table/Accountid eq 123.

Microsoft's material on the subject can be found here. https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#query-string-parameter-syntax-for-filtering

The top half of the course has been updated to work for filtering reports in the appor work space. You must provide the page and filter in a similar manner for the embedded link https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure to filter the embedded report. As a result, your link will look like this:

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

Unlock the Power of Data with Our Comprehensive Power BI Training!