Forum Discussion
Displaying different data sets on the same report
cheesepudding wrote:
Hello,
I have a report which is constant among clients but would like to display data that is stored on different databases depending on which client is logged in.
I have the report up on power bi embedded. Is there anyway to change the embed token to change which dataset is being displayed?
Thanks,
Cheese Pudding
you can do either
- Create and publish indivisual reports using different databases and embed reports according to the visiting customers.
- Gather all data together, create and publish one report, apply Row level security according to the visiting customers.
So there is no way to have created only one embedded report and change the back end dataset?
cheesepudding wrote:
So there is no way to have created only one embedded report and change the back end dataset?
Technically, there is one way to create only one embedded report. You can update connection strings for datasets in DirectQuery mode everytime one user accesses the report accordingly, however, per my test, there're some minutes delay before the new connection work. For example, when userA accesses the report, in your code, before the report rendering, you update the connectionstring, however the userA may still see the data that was from another user.
Related REST APIs FYI.
Set All Connections-to update connection strings.
Set Credentials - to update credentials, the gatewayid and datasourceid are from Get BoundGatewayDatasources.