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!

Related Queries

How can I create dynamic parameters in Power BI using DAX?

How to Auto Login Power BI HTML Static Application?

What debugging tools or methods do you use to pinpoint and resolve DAX or Power Query coding errors?