The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am working on an automation workflow where I want to use PowerBI APIs but I'm unable to do so as Application Level Permissions missing for Power BI Rest APIs in Azure.
To start with -
1. I created a Trial Account for Fabric where I have access to all the pro features for 60 days
2. I'm using Microsoft Azure Trial plan
I am an administrator of the tenant associated with my domain, and I’ve created an Azure app registration to automate Power BI report and dataset generation using the REST API. However, the "Power BI Service" application permissions (such as Dataset.ReadWrite.All, Workspace.ReadWrite.All) are not showing under "Application Permissions" in my Azure portal. My app is only able to access delegated permissions.
I’ve already taken the following steps:
- Enabled “Allow service principals to use Power BI APIs” in the Power BI Admin Portal
- Granted admin consent to all required delegated permissions
- Created an Azure AD app registration with appropriate API access
- Verified that I am a Global Administrator for this tenant
I'm stuck now. Can anyone please help here?
Your responses will be highly appericiated.
Thanks in advance!
Hi @Nipun0801
You're trying to automate Power BI tasks using the REST API via an Azure AD app registration, but you're encountering a roadblock because application-level permissions (App-Only) like Dataset.ReadWrite.All and Workspace.ReadWrite.All aren't appearing under "Application Permissions" in your Azure portal. Instead, you're only seeing delegated permissions, which require a signed-in user context. This issue arises because, although you've taken the correct preparatory steps—including enabling "Allow service principals to use Power BI APIs" in the Power BI Admin Portal, registering your app in Azure AD, and confirming you're a Global Admin—Power BI currently supports App-Only permissions only in tenants with active Premium capacity (P1 or higher), not just a Pro or Fabric Trial license.
Your Microsoft Fabric Trial does grant access to many Pro-level features, but it does not enable the App-Only permissions model for the Power BI REST API, which is why those permissions do not appear under the "Application Permissions" section. App-only authentication for Power BI REST APIs is tightly coupled with service principal support, which is only fully available in tenants that have dedicated Premium capacity (e.g., P1 SKU or higher). This limitation prevents service principals from acting independently of a user without the right licensing tier.
To resolve this, you'll need to:
Upgrade to a P1 or higher capacity (not just the Fabric Trial), or
Continue using delegated permissions with an interactive login (e.g., via Authorization Code flow), which requires a user session.
Hi @Poojara_D12,
Thanks for your response!
I understood that I need P1 license to use Application Level permissions, but can you please confirm that there are APIs available to post data to Power BI? My use case is to post data to power BI using APIs and then automatically generate the dashboards in Power BI.
I understood that I need P1 license to use Application Level permissions,
not sure what you mean by "P1" (a Power BI Premium Capacity SKU?) but it is likely unrelated.
My use case is to post data to power BI using APIs
Please be more specific. Do you want to push rows into a Power BI Streaming dataset or do you want to push data into a fabric storage artifact?
Hi,
I have been in touch with Microsoft Support Team for the resolution of this issue. Let's see if we really have any option.
Will post the status here.
Long standing gap. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com