495 questions
PowerBI report in Azure
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 87%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shyam Kumar
846
Reputation points
We are building a pipeline to deploy Power BI reports and components based on Option 2 outlined in
https://learn.microsoft.com/en-us/fabric/cicd/manage-deployment
.
Could you let us know if there are any existing implementations or best practices, we can use for deploying Power BI reports to Dev, QA, and Prod environments?
Azure DevOps
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 77%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sai Prabhu Naveen Parimi 2,265 Reputation points Microsoft External Staff Moderator2025-05-07T07:33:45.3566667+00:00 Thanks for sharing that you're following Option 2 from the Microsoft Fabric CI/CD guidance.
That’s a great approach. Based on that, here are a few suggestions to help streamline your deployments across Dev, QA, and Prod:
- Use the Power BI REST APIs to automate publishing of
.pbixfiles into different workspaces. - Organize your environments using separate workspaces (e.g., Project-Dev, Project-QA, Project-Prod).
- Use deployment pipelines to manage report promotion and set up parameter rules environment-specific settings like data sources.
- Store your report files in Source control (like Git) for version tracking using the PBIP format if possible.
- Use a service principal for authentication in your automated scripts or pipelines.
- Use the Power BI REST APIs to automate publishing of
-
Shyam Kumar 846 Reputation points
2025-05-07T07:49:32.9233333+00:00 Hi Sai,
How does Power BI REST APIs will automate report generation from pipeline
could you please provide high level steps?
-
Sai Prabhu Naveen Parimi 2,265 Reputation points Microsoft External Staff Moderator
2025-05-08T05:34:44.0566667+00:00 Just to clarify up front — Power BI REST APIs don’t generate reports from scratch, but they can help you automate the deployment of
.pbixfiles across different environments (Dev, QA, Prod) as part of your pipeline.Here’s a high-level overview of how that process works:
1. Set Up Authentication Register an app in Azure AD and use a service principal or user account to authenticate with the Power BI REST API. Grant it permissions to access the Power BI service.
2. Get Access Token Once authentication is set up, request an access token from Azure AD. This token will be used in your API calls.
3. Publish Report Use the Import API to publish your
.pbixfile to a specific workspace:POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/imports?datasetDisplayName={datasetName}Attach the.pbixfile in the request body.4. Get Report Details After publishing, use the Get Reports API to confirm the deployment and retrieve report metadata.
5. Update Credentials (if needed) If the report uses specific data sources, update credentials or connections using the Update Datasource API.
6. Automate via CI/CD You can then integrate all of these API steps into your pipeline (e.g., Azure DevOps or GitHub Actions) for seamless deployments to Dev, QA, and Prod environments.
This makes your Power BI deployments repeatable, secure, and easier to manage across environments.
-
Shyam Kumar 846 Reputation points
2025-05-08T06:46:11.9966667+00:00 Hi Sai,
Could you please answer my follow up questions:
1.
We are talking about deploying power BI report using CICD right?
2.
The steps you have outlined is before generating reports or after genearating reports?
3.
What is the .pbix files?
4.
What envirounments you are referring?
5.
what is the app you are referring? which app you are registering?
Note:
The user is looking for existing implementations, guidelines, and best practices for deploying Power BI reports and components across Dev, QA, and Prod environments, specifically using Azure DevOps (AzDo) as a starting point for their development.
6.
so what is the order I should follow to suggest him? and I mean where to start actually?
-
Sai Prabhu Naveen Parimi 2,265 Reputation points Microsoft External Staff Moderator
2025-05-09T09:49:45.9966667+00:00 Thanks for your follow-up !
Since you're focusing on deploying Power BI reports using CI/CD (specifically Option 2 with Azure DevOps), here are a few key resources that should help you get started
Documentation
- Use source control with Power BI in Microsoft Fabric
- Get started with Git integration for Power BI
- Power BI projects and developer workflows
Video Walkthrough
Automate Power BI Deployment – YouTube
If you face any issues or want to discuss a specific implementation, feel free to open a new thread here: Microsoft Fabric Community – General Discussion
-
Shyam Kumar 846 Reputation points
2025-05-13T11:05:05.3533333+00:00 Can you share any relavent video from MS as above video is not from MS. and do we need to create power BI service connection also?
-
Shyam Kumar 846 Reputation points
2025-05-13T12:06:41.12+00:00 I have edited the comment above , please suggest.
Sign in to comment
Sign in to answer