topic Re: Displaying different data sets on the same report in Developer

Displaying different data sets on the same report

cheesepudding — Wed, 22 Nov 2017 06:06:48 GMT

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

Re: Displaying different data sets on the same report

Eric_Zhang — Thu, 23 Nov 2017 01:35:10 GMT

@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

@cheesepudding

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.

Re: Displaying different data sets on the same report

cheesepudding — Thu, 23 Nov 2017 04:58:09 GMT

@Eric_Zhang

So there is no way to have created only one embedded report and change the back end dataset?

Re: Displaying different data sets on the same report

Eric_Zhang — Thu, 23 Nov 2017 09:23:34 GMT

@cheesepudding wrote:

@Eric_Zhang

So there is no way to have created only one embedded report and change the back end dataset?

@cheesepudding

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.