Unanswered

Dynamic URL filtering for embedded Dashboard Tiles in Portal

(0) Share

Report

Posted on by tsnowden

Hello,

I'm building a portal that will filter PBI reports and dashboards by vendor(lots of vendors). I've been using the below method of url filtering with liquid for filtering PBI reports, but I'm not sure how to apply it to dashboard tiles:

Reports:

{% capture [PBIVAR] %}https://app.powerbi.com/groups/[GUID]/reports/[GUID]?filter=[TABLE]/[COLUMN] eq '{{user.contact_customer_accounts.[COLUMN]}}'{% endcapture %}

{% powerbi authentication_type:"powerbiembedded" path:[PBIVAR]%}

I know that I can use webroles to filter dashboards, but I'd rather use a value that already exists to filter instead of setting up new roles in PBI for each type of user.

Help! ... and thanks.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

oliver.rodrigues 9,475 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Is this working as expected? {{user.contact_customer_accounts.[COLUMN]}}

I feel like you need to do a few extra things here

is this a 1:N or a lookup field: contact_customer_accounts

if it's a lookup you can get the GUID or primary name, but not other attributes, so you need to retrieve the record, and then get the attributes

Available Liquid objects - Power Apps | Microsoft Docs

hope this makes sense

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @tsnowden

Basic things to achieve what you are expecting.

1. Use Power BI RLS and apply a filter

2. In Portals/ Power pages > Create a web role and use Azure AD or Azure AD b2C to login

3. Instead of passing liquid > Power BI embedded will detect the unique id and apply the RLS Filter automatically for you.

PS: I have done the session last year. I will try to get the video link for this.

Have fun.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
tsnowden 11 on at

Like (0)

Report
Copy link

Link copied!

I was hoping to avoid using RLS and building roles to solve this since it requires each report to have a view built in PBI for each role. It does work, though...

Was this reply helpful? Yes No
tsnowden 11 on at

Like (0)

Report
Copy link

Link copied!

Yep, this works for my reports just fine. I just don't know how to produce a filtered dashboard tile.

Was this reply helpful? Yes No