Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am trying to access the rest API to refresh a dataset, and I am running into authorization problems. I need to use an app registration from azure. I create an Authorization context with my client Id and secret, which works with other azure services, but whatever I do I just get unauthorized. Here are the details:
I have assigned permissions in Azure AD to allow Power BI Service (Power BI), including 'Read and Write all Datasets' and 'View all Datasets'. When I try to access this rest endpoint, https://api.powerbi.com/v1.0/myorg/datasets, I just get unauthorized. Am I missing a step here? I think I need to use this call first so that I can get the guid of the dataset to refresh.
Was there a resultion for this issue. I am having the exact same problem. All documented access has been given and still get unauthorized
You need to give the App the corresponding permission to access Power BI resources:
Follow the steps below:
Register an Azure AD app to embed Power BI content
https://docs.microsoft.com/en-us/power-bi/developer/register-app
Follow the Through Azure Portal part.
Regards,
Michael
I went through those steps a couple of different times, and it hasn't worked. I have tried creating a user using the pbi developer access page and using the azure ad portal directly. I still only get an 'Unauthorized' response.
One part I can't follow is granting the AD permission "Access the directory as the signed in user". My org prohibits this but it doesn't seem necessary anyway since I am not doing impersonation. Also, in my case I am using a web API instead of a native application type. Is this required for accessing the dataset refresh API?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
6 | |
5 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
2 |