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 dou...
Need Help
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!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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