cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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/

Highlighted
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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Kudoed Authors