Power BI Embedded changing Report

[Anonymous]

Hi!

We have an App which is expected to show complete reports or visuals on it. We want to avoid extra logins, so we are betting for Power BI Embedded with token authentication, but we have some doubts regarding the functionality that we want to bring.

We have a DB per customer as a source, so we are thinking of creating a workspace per each of our customers and then upload the same set of reports to each of the Workspaces but each of them pointing to his database.

Basically, what we expect is that having a Report called ReportA (the same in all workspaces) if Customer 1 opens the APP the Report A that he sees is the one that is in the Customer1 Workspace, but if the one opening the APP is Customer 2, he should see the ReportA that is the Customer 2 Workspace.

We guess it's as easy as changing the URL or the report ID on the embedding code of the APP depending on the Customer that is login but maybe there are other limitations we're not considering.

Thank you soo much for all your comments in advance!

[v-shex-msft]

Hi @Anonymous,

>>Basically, what we expect is that having a Report called ReportA (the same in all workspaces) if Customer 1 opens the APP the Report A that he sees is the one that is in the Customer1 Workspace, but if the one opening the APP is Customer 2, he should see the ReportA that is the Customer 2 Workspace.

Perhaps you can take a look at RLS based on username, it can dynamically filter on the report to display corresponding contents.

RLS with UserName() 

Row-level security with Power BI Embedded 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi,

Already thought about that, but given that the data of each customer it's in a different database, each dataset will have a different connection string. The possibility of fo mixing all customer's data in an intermediate layer and using RLS is discarded for the moment.

Thanks for your ideas anyway!!

[v-shex-msft]

Hi @Anonymous,

It is possible to set filters or add key fields on your database side? AFAIK, power bi embedded also works with query parameters.
You can try to use this interaction with the backend data source or try to submit an idea to improve the RLS feature with your scenarios.

Edit parameter settings in the Power BI service 

Power BI Embedded Query Parameters API 

Regards,

Xiaoxin Sheng