PowerBi Rest API Datasets - Update Parameters Using Service Principal

[patiln]

Hello All,

The Get method works fine when running my PowerAutomate flow using Service Principal. But when I try to update parameters ,

The dataset is owned by the process account, with the data source credentials tied to the OAuth for that process account. However, in order to update parameters via API (see https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters-in-group), you first must be the owner of the dataset. Therefore, the flow utilizes default.takeover (https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/take-over-in-group) so the service principal can update the parameters. However, because the service principal does not have OAuth credentials, Power BI refresh fails because the data source credentials are missing once the dataset is taken over. The very last step of the flow seems to be having the process account take back over before refreshing the dataset. I attempted to update the dataset user back to the process account via https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/put-dataset-user#datasetuseraccessright after the parameters were updated by the service principal, but that threw an error, so I’m not sure that’s either the wrong approach or I’m doing something wrong. It feels like we’re so close! Can you help us get over this remaining hurdle?

[arvindsingh802]

@patiln  - Can you help why you need to update the parameter each month ? thinking if I can help with some alternate approach

[Anonymous]

Hi @patiln ,

Could you please go to the semantic model settings and take over it manually?

Best regards,

Joyce

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

[patiln]

Hi Joyce,

We are automating this process to reduce/eliminate the monthly manual work , so it won't be feasible to manually take over the flow and revert back every time. If you do have an alternative way to update PowerBI parameters using API ,you could share those as well. Thanks!!