How to update the Parameter in Power BI Dataset using PowerBI Rest API?

[abhishek-kumar]

Hi

I have Published the Power BI Reports with Parameters, and I'm trying to update the Parameter by the PowerBI Rest API with required scope. I am using Azure AD App with "Dataset.ReadWrite.All" Permission for generating access token. If i used the token in that API, it is showing me 403 forbidden error. I have allowed all the access for that App. I enabled all the required fields in the Workspace access.
Can you please guide me how to use that API and how to generate the Token for the API?

[aj1973]

Hi @abhishek-kumar 

The user of the API must be the owner of the Dataset

App Registration can't Take Over the ownership of the dataset in the service.

[abhishek-kumar]

HI @aj1973 

I have generated the access token with the "Dataset.ReadWrite.All" as delegated permission and the owner of the Dataset is the signed in user. But still it is giving me 403 forbidden error.

[aj1973]

You said 

Did you mean the Power BI App Registration? if so then you Azure AD App can't be an owner of the dataset.

[abhishek-kumar]

For now Im using Azure AD App not the Power BI App Registration. I have the Dataset.ReadWrite.All as Delegated Permisison in Azure AD App. Im Generating Access token in Site Page as the Signed in user (That user is the Owner of the Dataset.)

1. Should I use Power BI App Registration?
2. Is it possible to assign the azure ad app as the Owner of the Dataset?

[aj1973]

No Neither one can be the owner of the dataset.

It is better that you create a service account for your required scope. May I know what is the scope please?

[abhishek-kumar]

Dataset.ReadWrite.All is the Required Scope to update the Parameter in Power BI Dataset
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters