topic Parsing a variable to filter dashboard in web embedded report in Developer

Parsing a variable to filter dashboard in web embedded report

ddeveny — Mon, 25 Jul 2016 02:12:22 GMT

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

Re: Parsing a variable to filter dashboard in web embedded report

kobaldm — Mon, 25 Jul 2016 07:54:08 GMT

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/

Re: Parsing a variable to filter dashboard in web embedded report

PowerDAX — Tue, 26 Jul 2016 01:17:54 GMT

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.