Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ddeveny
New Member

Parsing a variable to filter dashboard in web embedded report

Hi,

 

We have a report that we have published to and embeddable web dashboard.

 

The dashboard reports a series of scores for eachh of our clients business.  We have a filter box on the dashboard that allows us to select which client's results we want to see.

 

We want to be able to send our clients an url like this

 

www.cuckoocreative.com.au/dashboard?i=brandname

 

Where brandname is the customers name and the dashboasrd then only shows the data for that client without having to create a dashboard for each client.  We are naticipating creating quite a few and want it o work on-the-fly.

 

We can do everyhting else we ant to do in javascript but we just can't access and manipulate the iFrame content via scripting.  Of course!  It's a security measure.  The iFrame needs to come from the same domain/origin for us to be able to manipulate it.

 

Is there anyway we can setup the embeddable dashboard to accept a filter variable?

 

Any help would be appreciated.

 

Thanks

 

Dave

2 REPLIES 2
PowerDAX
Resolver III
Resolver III

As noted, you could utilize RLS to facilitate this but it would take a bit more configuration (adding users to a table that mapped users to brand):  https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-app-token-flow/

 

What you are likely looking for is passing a filter via URL.  In this case, brand would be in the filters pane, not a visible filter/slicer.  See this link and information here:  https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-iframe/

 

Filter a report

You can filter an embedded report using a URL syntax. To do this, you add a query string parameter to your iFrame src url with the filter specified. You can Filter by a value and Hide the Filter Pane.

powerdax.com
kobaldm
Helper I
Helper I

You should check out row level securty in the newest Version of PowerBi. This way you only need to create a correct token see this post

 

https://powerbi.microsoft.com/en-us/blog/what-s-new-and-what-s-next-for-power-bi-embedded-july-2016/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.