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?
