Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |