Forum Discussion
Automate Power BI Deployment & Data Refresh via GitHub Integration
That looks promising chethan4046. Power BI supports Github and Azure DevOps better (kind of sad for Bitbucket) so yeah there is a good chance that it could be done cleanly. Give it a go! I might also give it a try over the weekend and thanks for sharing them!
Super UserHi chethan4046 ,
I was able to achieve this with Bitbucket pipelines and I think the process will be similar with Github Actions. And I am assuming you are already using PBIP format since you mentioned you have been doing version control for a while. The key components are Service Principal ( basically a robotic user that will authenticate to the workspaces and carry out the deployments), Fabric APIs. These two will automate the deployment part and to trigger the deployment process you will use Github Actions to trigger it on branch merges (say if you merge to main, it will automatically trigger the deployment to your designated workspace).
I think the main APIs were Set-FabricAuthToken (to authenticate to the workspace), Invoke-FabricAPIRequest (to get workspaces and items list) and Import-FabricItem (does the actual deployment). I don't remember if I added the refresh part though as I already had quite frequent schedule refreshes (but I should revisit that part).
I hope you have fun doing it and I hope that this helps!
- alish_b
P.S. Remember to grant rights to the service principal to the workspace and the connections used. I had to go down a rabbit hole because I had not done that.
Hi alish_b Thanks.
I am trying to use this method. What is your opnion on thisHere are the relevant APIs and documentation links.
Git (Fabric API):
Documentation: https://learn.microsoft.com/en-us/rest/api/fabric/core/gitExample API:
POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/git/updateFromGitThis API can be used to update/sync the workspace from Git.
Dataset Refresh (Power BI API):
Documentation: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-datasetExample API:
https://api.powerbi.com/v1.0/myorg/groups/$WORKSPACE_ID/datasets/$DATASET_ID/refreshesThis API triggers a dataset refresh in the specified workspace.
- alish_b
That looks promising chethan4046. Power BI supports Github and Azure DevOps better (kind of sad for Bitbucket) so yeah there is a good chance that it could be done cleanly. Give it a go! I might also give it a try over the weekend and thanks for sharing them!
v-menakakotaCommunity Support
Hi chethan4046 ,
I would also take a moment to thank alish_b , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the issue has been resolved. If you continue to experience any problems, please reach out here and we will assist you.Best Regards,
Community Support Team
