PBI Embedded for ISV's DataSet Refresh

[Anonymous]

Hi all,

We're an ISV with Multiple Customers on our Tenant with their own Workspace.

We've setup a single Service Principal and run Embedded as App Owns Data.

We want to create in our UI, a refresh button that refreshes the Dataset linked to the report in the UI via the Power BI REST call.

We do not want to expose the access token to the UI as Client could then get access to other Workspaces.

Is this possible to do? I can't see anything in the 'Client API' documentation.

We would like to do this without creating back-end API's for the UI to call, and they call the PowerBI API's.

[Anonymous]

Thanks Henry, but I need to refresh the underlying Dataset, and not just the Report. I can't see any way of doing this other than running the rest API which requires a system wide access token.

We don't use Direct Query, so simply refreshing the report won't refresh the underlying data.

I was trying to work out if the Embed Token can be used to run REST API's, but don't believe it can.

[v-henryk-mstf]

Hi @Anonymous ,

According to my understanding, this is feasible. Refer to the following blog: How To Embed Power BI Reports Into Your Application? (loginworks.com)

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes, but as we're using a Service Principal with multiple workspaces (for independent clients), if I give the UI the Access Token, technically users will be able to run API's for ANY Workspaces using the Access Token for the Service Principal (which we cannot do)

[v-henryk-mstf]

Hi @Anonymous ,

Hope the solution provided can help you.

Link: 

Solved: Power BI embedded- Apps Owns Data - Microsoft Power BI Community 

Solved: Power BI Embedded Refresh - Microsoft Power BI Community

Best Regards,

Henry.