topic Re: Send Report Link with filter value in Developer

Send Report Link with filter value

devGV_88 — Tue, 20 Sep 2022 16:44:32 GMT

Hi folks!

I'm using PowerApps for PowerBI to give users detail about someting and give them access to edit the record.

Into PowerBI, I created a "FirstPage" with the items list and other as "Details" with the PowerApps app where the user can make their changes.

In PowerBI, I'm able to select the row (in the FirstPage) and go to the Details to work with this specific row. Using the "drill-through" field (Id) and everything is fine.

But also I want to send an email to user/s when they have an item assigned with the the URL to the specific Item towards the "Details" page.

I tried some things like: <url power bi> + >report section> + ?filter=<table>/<field> eq <value>

But, the URL doesn't works or PowerBI say "Getting your data"

Could you help me to make the correct URL?

Re: Send Report Link with filter value

v-chenwuz-msft — Wed, 21 Sep 2022 08:09:09 GMT

Hi @devGV_88 ,

The Query string parameter syntax for filtering is:

URL?filter=Table/Field eq 'value'

Table and Field names are case-sensitive, value isn't.

For more details you can refer this link:

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Send Report Link with filter value

wsdcawefwqrevfq — Wed, 22 Feb 2023 20:46:51 GMT

I've been trying this and each time I get the error message:

You don't have access to view this page.

TECHNICAL DETAILS
Power BI was unable to read the application metadata. Please check the Power BI service status in the below support page and try again later.

The URL ends with:

(question mark)filter=NCDR_Aging_Report/BAANSupervisor eq 'John Dough'

Using just the URL itself opens the report fine.