Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dataset refresh REST API, Service Principal Not Authorised

Hi all,   I'm trying to trigger a refresh via the Rest API using a service principle registered app. So far, the app has been granted all PowerBi permissions in Azure, it is also part of a a securi...
Need Help
Tutorial Requests
  • mariussve1's avatar
    mariussve1
    4 years ago

    Hi,

    I think you need to add the SPN as admin in the Workspace where your dataset is stored. The best way to do this is, if you havent already done this, is to put the SPN in a Security Group in AAD. Then grant this security group admin access to the workspace. After you have granted access it can take a while before the access has been granted, so I suggest to wait 30 min before trying the REST API again.

     

    Br
    Marius

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI Anonymous,

As the document mentions, this refresh API required an additional option 'notifyOption' in the body. I'd like to suggest you add it to your request and try again:

Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

BTW, what type of data source are you working on? If you mean Azure Analysis Services, it seems to need additional permission for that instance.

Regards,

Xiaoxin Sheng