Problem with Permissions in Managed Identity for Power BI API Refresh

max-s21 — Wed, 15 Feb 2023 09:54:32 GMT

I am currently developing an Azure function that is supposed to trigger the Power BI API to refresh a Power BI dataset. I have registered my Azure function as a managed identity and added it to a security group in Azure AD that has access to the Power BI API. However, when i try to refresh the dataset using the Power BI API, i am encountering a problem with permissiond in the token provided by the managed identity credential function in my Python Azure function. I have also tested my function for several other features, like reading all datasets in one workspace (because you only need read.all permissions then) but it doesn't work.

I have followed all the necessary steps to grant the managed identity the required permissions, but i am still not able to refresh the dataset. I have decoded and checked the managed identity token and it seems to be missing the necessary permissions. I cannot see any permission (the whole "scope" part is missing)

Has anyone else encountered a similar issue when using a managed identity to access the Power BI API? If so, can you share any solutions or suggestions that might help me resolve this issue?

Any help would be grantly aprreciated. Thank you!

Re: Problem with Permissions in Managed Identity for Power BI API Refresh

NandanHegde — Thu, 16 Feb 2023 03:39:05 GMT

This is the one I am referring :

https://datasharkx.wordpress.com/2022/11/05/refresh-power-bi-dataflow-dataset-from-azure-data-factory-synapse-pipeline-via-managed-identity/

Follow first 2 steps for access aspects

topic Re: Problem with Permissions in Managed Identity for Power BI API Refresh in Developer

Problem with Permissions in Managed Identity for Power BI API Refresh

Re: Problem with Permissions in Managed Identity for Power BI API Refresh