Forum Discussion

NicolasLJ's avatar
NicolasLJ
Frequent Visitor
2 years ago
Solved

Power BI API : GET Refresh works, but POST does not

Hi,   I'm testing Dataset refresh through API with Postman. I created and registered an app in AD with Dataset.ReadWrite.All Granted When I send a GET resquest with a Bearer Token I get the histo...
Need Help
aj1973's avatar
aj1973
Community Champion
2 years ago

Hi NicolasLJ 

The App registration doesn't need  Bearer tokens to connect to the service. You need to use your App Regsitration in a local machine and Powershell to execute the script.

NicolasLJ's avatar
NicolasLJ
Frequent Visitor
2 years ago

I will provide more context :

My objective is to add a button to refresh on demand a dataset in a low code application build with retool.com

 

My setup :

- An App registered in AD (Service principal) with all permissions required and granted by admin

- My app is admin in my PBI workspace

- My Retool App will authenticate with the app id and secret through Oauth2 authentification flow

- Before coding the API orchestration in retool I try to test the all flow with Postman to ensure everything is well configured in Azure and PBI.

 

I succesfully :

- get the token

- get historical refresh info from a GET request to https://api.powerbi.com/v1.0/myorg/datasets/xxxxx/refreshes

(I replaced dataset id with xxxxx in this message for confidentiallity)

 

But when I POST to the same url with same auth token, I got ta response with this body in Postman :

 

{
    "error": {
        "code": "ItemNotFound",
        "message": "Dataset xxxxx (I replaced by dataset id in this message for confidentiallity) is not found! please verify datasetId is correct and user have sufficient permissions."
    }
}