Richard Swinbank improves on a prior version control system:
In the previous post, I outlined a possible workflow for Power BI development, and implemented an Azure DevOps pipeline to show how steps in such a workflow could be automated. To build the pipeline I stored an entire
.pbixreport file – data and all – in version control, which is a problem for at least two reasons:
- storing large report files in a version control system won’t scale well
- datasets may contain confidential or sensitive data which must be kept out of version control.
In this post I’ll look at separating a report’s dataset from its visuals, version controlling the standalone dataset (without data), and deploying the dataset automatically to Power BI.
Read on for the process.