topic Re: Power Bi Embedded - Dynamic Binding in Developer

Power Bi Embedded - Dynamic Binding

kian0417 — Wed, 17 Jun 2020 10:03:47 GMT

Hi Team,

I would like to design the dashboards & reports and embed them in my web application.

Users will just be using our web application.

I want to create the dashboards/reports once for all our users to use.

Then I require the dashboards/reports to have dynamic binding to connect to different datasets/databases based on the user's login.

I.e. when users log in as Company A they will only see “ Company A” data presented on the dashboard.

When users log in to “ Company B” they will only see “Company B” data presented on the same dashboard.

However, the most important thing is to be able to change the connection/data at run time dynamically through the web application code.

Is it possible to achieve and how can I do it? Thanks.

Re: Power Bi Embedded - Dynamic Binding

Anonymous — Wed, 17 Jun 2020 22:22:01 GMT

Hi @kian0417

Sounds as though the 'Dynamic Binding' settings should work for you: https://github.com/microsoft/PowerBI-JavaScript/wiki/Dynamic-Binding

A report can have its data source changed at the point of creating the embedding configuration.

I notice that the wiki doesn't mention Dashboards though - so you might have to test it to see if it works. The behaviour might be different with dashboards as each dashboard can already bind to multiple data-models, so it might not be possible to specify a new set of ID's to bind to.

Be sure to check the known limitations on that Wiki page too - as there are a couple of additional things to consider.

Re: Power Bi Embedded - Dynamic Binding

kian0417 — Thu, 18 Jun 2020 09:29:55 GMT

@Anonymous

Hi, thanks for your reply.
I had tried and put in different dataset ID but the report still remain and no any changes.

Re: Power Bi Embedded - Dynamic Binding

Anonymous — Thu, 18 Jun 2020 14:56:27 GMT

Have you confirmed that you aren't hitting any of the known limitations?

Limitations and considerations

The dynamically selected dataset must have the same data schema used in the report.
When embedding for your organization, you'll need to generate an embed token using the new API.
When embedding for customers, the user has to have permissions for both the report and dataset.
Only the new workspaces are supported. The report and datasets must be inside a new workspace.

I am yet to try this functionality - so cannot confirm what would happen if this is misconfigured. I would have expected an error as opposed to the report simply rendering as before.

Re: Power Bi Embedded - Dynamic Binding

kian0417 — Fri, 19 Jun 2020 08:50:04 GMT

I used another way (row-level-security) to achieve this goal, by the way, thanks to you.

Re: Power Bi Embedded - Dynamic Binding

Anonymous — Mon, 13 Jul 2020 16:29:43 GMT

I can confirm dynamic binding works pretty well for a multi-tenant SaaS app. So, basically single report template, many datasets, all bound at run time.

I still have not yet figured out how Printing works with dynamic daasets.

To get this to work, the front end "embedd config" needs to indicate datasetBinding, and the Embedd token generation needs to reference the datasetID. (backend)

phil