Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm configuring an Azure AD application to access the Power BI REST API.
I’ve already registered the app and navigated to API permissions > Add a permission > Power BI Service > Application permissions, but I don’t see the 'Dataset.Read.All' permission listed.
I do see other permissions like:
Tenant.Read.All
Tenant.ReadWrite.All
But nothing related to datasets under "Application" type.
Does anyone know why 'Dataset.Read.All' is missing for Application permissions?
Is this permission only available under Delegated permissions?
Solved! Go to Solution.
Hi @rodrigo09062015 ,
Thanks for your response. You can capture a specific visual from a Power BI report using the Export To File API, but there are a few things to keep in mind.
1. The report needs to be in a workspace with Premium or PPU capacity
2. You’ll need to use a service principal to make the export call
The visual needs to be part of a report, not just placed on a dashboard. Dashboard tiles aren’t currently supported by this API, but as long as your visual is on a report page, you can export it as a PNG, PDF, or PPTX file. Dashboard tiles aren’t supported in this API, but if your visual lives on a report page, you’re good to go and you can export it to PNG, PDF, or PPTX.
Here are some useful links to help you get started
Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
I Hope this helps.
Thanks ®ards,
Yugandhar.
Friends,
Thank you for the response.
It’s clear to me now.
My initial goal was to try to use the API to capture an image of a specific visual from a dashboard. I must admit I don’t know if it’s possible to do this via the Power BI API.
If any colleague knows whether it’s possible and can share tips or how to do it, I would appreciate it.
Hi @rodrigo09062015 ,
Thanks for your response. You can capture a specific visual from a Power BI report using the Export To File API, but there are a few things to keep in mind.
1. The report needs to be in a workspace with Premium or PPU capacity
2. You’ll need to use a service principal to make the export call
The visual needs to be part of a report, not just placed on a dashboard. Dashboard tiles aren’t currently supported by this API, but as long as your visual is on a report page, you can export it as a PNG, PDF, or PPTX file. Dashboard tiles aren’t supported in this API, but if your visual lives on a report page, you’re good to go and you can export it to PNG, PDF, or PPTX.
Here are some useful links to help you get started
Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
I Hope this helps.
Thanks ®ards,
Yugandhar.
Hi @Jai-Rathinavel ,
Just checking in has your issue been resolved? Was my response helpful, or would you like more details or clarification? Feel free to let me know if there's anything else I can assist with.
Thanks &Regards,
Yugandhar.
@rodrigo09062015 If you want to give service principal access on a Workspace level then add that Service Principal as a member to that workspace and try executing the Get Datasets API. You don't have to provide any delegated permissions on the Azure Portal.
Proud to be a Super User! | |
Hi @rodrigo09062015 ,
Thank you for engaging with the Microsoft Fabric Community. Just to add a bit more context to @anilelmastasi , response. Dataset.Read.All isn’t available under Application permissions in Azure AD, which is expected. Reading or querying datasets requires user context, meaning someone must be signed in. That’s why Dataset.Read.All and Dataset.ReadWrite.
All are only available as Delegated permissions, used when an app acts on behalf of a signed in user through OAuth2. If your app uses a service principal or operates without user interaction, it relies on Application permissions, which don’t provide dataset level access.
Helpful refrence:
Embed Power BI content in an embedded analytics application with service principal and an applicatio...
Power BI REST APIs semantic model permissions - Power BI | Microsoft Learn
Microsoft Graph permissions reference - Microsoft Graph | Microsoft Learn
Hope this clears it up.
Regrads,
Community Support Team.
Hello @rodrigo09062015 ,
The Power BI API currently does not expose Dataset.Read.All under Application Permissions because dataset-level operations (reading/querying) generally require user context.
Only Delegated permissions include:
-Dataset.Read.All
-Dataset.ReadWrite.All
These are used on behalf of a signed-in user (OAuth2 flow where a user logs in).
If this solved your issue, please mark it as the accepted solution. ✅
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
4 | |
4 | |
4 |