Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI Embedded changing Report

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!

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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!!