Forum Discussion
Deploy Power BI reports from Azure DevOps
- 1 year ago
Hi Pker_Tank ,
Thanks for posting in Microsoft Fabric Community.To automate Power BI Deployment Pipelines using Azure DevOps and a Service Principal, please follow these steps:
1. Ensure the Service Principal has the following Power BI API permissions in Microsoft Entra ID (Azure AD):
-Workspace.ReadWrite.All – Manage all workspaces.
-Pipeline.ReadWrite.All – Manage deployment pipelines.
-Tenant.Read.All – Read tenant settings.
-Dataset.ReadWrite.All – Manage datasets.After adding these, an admin must grant consent in Azure AD.
2. Enable Service Principal Access in Power BI- In the Power BI Admin Portal, go to Tenant Settings.
- Enable "Allow service principals to use Power BI APIs" and specify the allowed security group.
Please follow the below link for details:
Embed Power BI content in an embedded analytics application with service principal and an application secret - Power BI | Microsoft Learn
3. Set Up Azure DevOps Service Connection
- Go to Azure DevOps -> Project Settings -> Service Connections.
- Create a new Azure Resource Manager connection using Service Principal (Manual) authentication.
- Enter the Tenant ID, Client ID, and Client Secret from the registered app in Microsoft Entra ID.
Please follow the below link for details:
Use an Azure Resource Manager service connection - Azure Pipelines | Microsoft Learn
4. Automate Deployment Pipelines Using Power BI REST APIs
Use Power BI REST APIs in your DevOps pipeline to:
- Create a Deployment Pipeline
- Assign a Workspace to the Pipeline
- Deploy and Promote Content
- Manage User Access
Please follow the below link for details:
Automate deployment pipelines with APIs for Power BI items - Microsoft Fabric | Microsoft Learn
Use service principals & managed identities - Azure DevOps | Microsoft Learn
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Best Regards,
Vinay.
Hi Pker_Tank ,
Thanks for posting in Microsoft Fabric Community.
To automate Power BI Deployment Pipelines using Azure DevOps and a Service Principal, please follow these steps:
1. Ensure the Service Principal has the following Power BI API permissions in Microsoft Entra ID (Azure AD):
-Workspace.ReadWrite.All – Manage all workspaces.
-Pipeline.ReadWrite.All – Manage deployment pipelines.
-Tenant.Read.All – Read tenant settings.
-Dataset.ReadWrite.All – Manage datasets.
After adding these, an admin must grant consent in Azure AD.
2. Enable Service Principal Access in Power BI
- In the Power BI Admin Portal, go to Tenant Settings.
- Enable "Allow service principals to use Power BI APIs" and specify the allowed security group.
Please follow the below link for details:
Embed Power BI content in an embedded analytics application with service principal and an application secret - Power BI | Microsoft Learn
3. Set Up Azure DevOps Service Connection
- Go to Azure DevOps -> Project Settings -> Service Connections.
- Create a new Azure Resource Manager connection using Service Principal (Manual) authentication.
- Enter the Tenant ID, Client ID, and Client Secret from the registered app in Microsoft Entra ID.
Please follow the below link for details:
Use an Azure Resource Manager service connection - Azure Pipelines | Microsoft Learn
4. Automate Deployment Pipelines Using Power BI REST APIs
Use Power BI REST APIs in your DevOps pipeline to:
- Create a Deployment Pipeline
- Assign a Workspace to the Pipeline
- Deploy and Promote Content
- Manage User Access
Please follow the below link for details:
Automate deployment pipelines with APIs for Power BI items - Microsoft Fabric | Microsoft Learn
Use service principals & managed identities - Azure DevOps | Microsoft Learn
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Best Regards,
Vinay.