Forum Discussion
Helper ILooking for guidance on development workflow
Hi folks,
We are using Power BI Pro & Desktop for several clients. We are struggling to create a workflow in which we create a report using Desktop, deploy into the equivalent of QA area and then finally to a production area.
The items I'm struggling with are:
1) How can I know what has changed between .pbix files?
2) How can I automate the document generation of measures in DAX and queries I write in M?
3) How do I manage source control of .pbix files?
To date, we are keeping local copies of .pbix files and pushing to the correct workspace. For the docs, we currently do this manually & it's getting to be a large time sink.
Any thoughts on how to improve the flow are appreciated!
Regards,
Rajesh
rajeshchawla for deployment, you need to look at the new deployment pipeline feature which just came this month as a preview. For version control I recommend my customer to use SharePoint and/or one drive. If there are multiple authors, they check out the SharePoint file and check back in with and log their changes.
For documentation, we use everything in Power BI, we have one model which is used as a source for report authoring, so basically a model contains all the documentation itself.
I'm sure there are other approaches but deployment pipeline is a big help since it came out.
Good luck.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
1 Reply
- parry2k
Super User
rajeshchawla for deployment, you need to look at the new deployment pipeline feature which just came this month as a preview. For version control I recommend my customer to use SharePoint and/or one drive. If there are multiple authors, they check out the SharePoint file and check back in with and log their changes.
For documentation, we use everything in Power BI, we have one model which is used as a source for report authoring, so basically a model contains all the documentation itself.
I'm sure there are other approaches but deployment pipeline is a big help since it came out.
Good luck.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!