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

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.