Power BI and Source Control Integration
Yes! This is a real problem with the Power BI team to source control Power BI report files (.pbix) with the team. I too have faced problem with it.
Questions arise:
- How to integrate Power BI files to a source control tool like TFS, SVN, Git, Azure DevOps, etc. as there is no Project structure available?
- Will we get proper versioning of .pbix files as they are not XML/JSON based as we get in case of SQL Server Reporting Services?
Different teams have adopted different ways to handle it.
One of the teams used Visual Studio to have a Solution with any project. Created Solution Folders to organize the report files and added all .pbix files to respective folders. Finally, associated that Solution to the TFS. Whenever they need to work on a particular report, open the Visual Studio Solution and double click on .pbix file. It opens the report up into Power BI Desktop. Work on it and save it. Come back to Visual Studio and Check-In. That’s it! Though, the real issue is Power BI Developer needs to have Visual Studio installed on their local system to make it work. The management questions, why a Power BI team needs to have Visual Studio??? Of course, they need to buy VS licenses for them.
Does it really maintains different versions of .pbix file? Technically a .pbix file is not a XML/JSON file the way we have SSRS reports. So, how does it maintain different versions of .pbix file? Practically, I have seen it working fine with TFS. God knows how it works, but it works, at least so far. Never got any issue from anyone on this.
I wish if Power BI team can integrate the Desktop tool to Azure DevOps the way Azure Data Factory team has done it for ADF V2 version. Azure Data Factory has implemented CI/CD in the Azure Portal itself. So, there is no need for Visual Studio and other stuff, which had been there with ADF V1 version earlier. Yes! I faced problem working on ADF V1 when it comes to sharing files with other team members. Hope, Power BI team does same sooner.
Let me know your experience on this issue.
How to find out Power BI Desktop Version, User ID and Session ID
It’s always good to have latest version of Power BI Desktop as Power BI team keeps on updating the Desktop tool. So, how to find out what version of Power BI Desktop you’ve been running???
Open up your Power BI Desktop, go to About and click it. It will open a new box displaying all the required details about Power BI Desktop. Take a look at below image:
I’ve rubbed the User ID and Session ID off from the image as that’s, I guess, the confidential info about my Power BI Desktop.
WPF and MVVM Training at L&T Technology Services, Mysuru, 11-15 Feb, 2019
Conducted WPF and MVVM training at L&T Technology Services, Mysuru during 11-15 Feb, 2019.
Have been working on ASP.NET MVC, Angular and React more often now-a-days. It’s been really great to have this session as I had worked on WPF and MVVM long back and was out of touch somehow. Feel Happy! I still remember all the concepts and could share my knowledge with the participants.
Had nice time with cool weather at L&T Technology Services!
Campus2Corporate Training at L&T Technology Services, Mysuru 29 Oct – 03 Nov, 2018
Just finished training at L&T Technology Services, Mysuru…Shared knowledge on OS Basic, Software Programming Fundamentals and PDLC/PLM, after long time covered these topics. Enjoyed a lot with you guys!
Campus2Corporate .NET Training at Opteamix, Bangalore 18 Sep – 26 Oct, 2018
Just concluded Campus2Corporate .NET training at Opteamix, Bangalore 18 Sep – 26 Oct, 2018. Really enjoyed training a small group with venue near to my home, great fun! Had fun playing Table Tennis at premises with the participants. Great time guys! 🙂
Campus2Corporate .NET Training at Siemens, Bangalore 04th July – 17th Sep, 2018
Conducted Campus2Corporate .NET training for 25 participants at Siemens, Bangalore 04 July – 17 Sep, 2018. Teaching fundamentals has always been nice experience to me, especially at Siemens, Bangalore. Having nice time with the participants on last day of training. Thanks for treat guys! 🙂
