Versioning in Power BI
Honey Bakliwal
Assistant Vice President | Ex S&P | Power BI | Power Apps | Microsoft DA-100 Certified| Microsoft DP-900 Certified| Azure Databricks| Jaspersoft BI Suite | Talend Open Studio | SQL Server | ADF | Oracle | RDBMS| Python
We all might have faced following issues while working with the deployment of a pbix file from desktop to Power BI service
· Mistakenly, pbix or dataset got deleted
· Missed the last deployed report from the Power BI service
· Manually maintain the versioning of the pbix’es file
To manage all these either we might be dependent on some other software’s or admin privileges on those software’s or having premium license on Power BI service to create the deployment pipeline, but I have been managing the version in a very simple way using SharePoint, here are the steps to do the same
· Create a pbix file in the Power BI desktop based on your business requirement
· Once the pbix is created, publish the report in the SharePoint at some desired location
· Once the pbix is published, open Power BI service and redirect yourself to the workspace for the pbix to be published
· Click on the Get data
· Click on the Files and click Get as shown below
· Click on the SharePoint as shown below
· Last step is to just pass the URL of the SharePoint page where the pbix was checked in as shown in the screenshot
· Once all these steps are completed, within a wait of 2 minutes the pbix will be published to the desired workspace
· All these steps are one-time effort, with the next release of the pbix you just need to check out the pbix in the SharePoint and upload the file and check in, and within 2 minutes of wait the updated pbix will be deployed back to the Power BI workspace