Service Principle API Authentication to Dataset Refresh Endpoints

Anonymous — Tue, 04 Jan 2022 11:44:02 GMT

Hello,

I am building a dataset of Power Bi admin data and a key requirement is to see the refresh status and refresh schedule of all the datasets in our service.

I authenticate using a service principle which has access to the admin APIs but not the other sections of the API.

e.g. the service principle account can authenticate to this: https://api.powerbi.com/v1.0/myorg/admin/datasets which gives a list of all the datasets and some information about them, but not the refresh info.

This call, not in the Admin API, gives the refresh information I am after: https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes

However, the bearer returned by authenticating with the service princilple account does not have access to this call.

Is there a way to authenticate the service principle to access other areas of the API, or is there call I am missing in the admin API to get the data I'm after?

Thanks

Re: Service Principle API Authentication to Dataset Refresh Endpoints

Watsky — Tue, 04 Jan 2022 16:55:00 GMT

Hey @Anonymous,

Try:

https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetid}/refreshes

Re: Service Principle API Authentication to Dataset Refresh Endpoints

Anonymous — Tue, 04 Jan 2022 17:06:50 GMT

Amazing, thanks!

topic Service Principle API Authentication to Dataset Refresh Endpoints in Developer

Service Principle API Authentication to Dataset Refresh Endpoints

Re: Service Principle API Authentication to Dataset Refresh Endpoints

Re: Service Principle API Authentication to Dataset Refresh Endpoints