How to pass parameter to my POWERBI embedded report

0 votes

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?

Feb 17 in Power BI by surbhi
• 3,810 points
419 views

1 answer to this question.

0 votes

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
answered Feb 17 by CoolCoder
• 4,360 points

Related Questions In Power BI

0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,350 points
1,275 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,350 points
787 views
0 votes
1 answer

Passing a parameter to Power BI Embedded via embedded URL

Add the following to the end of ...READ MORE

answered Oct 23, 2018 in Power BI by Annie97
• 2,160 points
3,804 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23, 2019 in Power BI by anonymous
• 33,010 points
4,475 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
522 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
1,770 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
604 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
693 views
0 votes
1 answer

How to bind multiple Power BI datasets to a single Power BI Report

This is not an option. These are ...READ MORE

answered Feb 21 in Power BI by CoolCoder
• 4,360 points
173 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP