CODEWITHSUNDEEP
continuous-integrationpowerbi
Ramandeep Arora
Ramandeep Arora

Reputation: 43

How to automate publishing of Power BI (PBIX) from desktop to Power BI Web with config for environment

  1. I currently have a desktop PBIX file that I manually publish to Power BI Web.
  2. I have to keep different version of the same PBIX file just to keep track of different sources based on environment such as Dev/QA/UAT/Prod etc
  3. I have more than one data source for each environment i.e. in same PBIX file I have data coming from say Application Insights and REST API.

I scanned through power bi community to see how to do this but can't find relevant information. All pointers are for refreshing either the local PBIX or using Schedule Refresh option in Power BI Web.

Someone even wrote code to hit Publish code via OLE automation but that's not acceptable solution.

https://community.powerbi.com

I would like to automate this process such that

A. I can provide the data source connection string/ credentials externally based on the environment I want to publish it to.

B. Publish the report to Power BI web using a service account instead of my own.

Our current build and deployment tool set does allow use of PowerShell/ Azure CLI etc. Hence it would be helpful if the solution uses those.

Upvotes: 1

Views: 1976

Answers (1)

Tarun Bhatt
Tarun Bhatt

Reputation: 827

Fetching data from sql Azure won't need refresh but it's expensive. In one of the organizations I worked for they used views on sql Azure to accomplish this task

Upvotes: 1

Related Questions