In this guide, I will walk through how you can use GitHub and Git to version control Power BI reports using the PBIP format. I wanted a way to track changes to Power BI models and reports over time, understand exactly what changed, and avoid overwriting work or passing PBIX files back and forth. In this video, I’ll show a practical workflow using Power BI Desktop, GitHub, and Git Bash that makes version control possible without relying on Fabric or Premium features.

In this guide, I will show how to use Python and APIs to connect to data sources that Power BI doesn’t support with built-in connectors. I wanted to build a Power BI dashboard for our YouTube channel to track views and other activity, so I connected to the YouTube Analytics API with a Python script and pulled the data into my Power BI model. Normally, I could export data manually from YouTube Studio, but that takes time and needs to be repeated each time I want updated results. This approach also avoids relying on spreadsheets in Google Drive or OneDrive as intermediate storage.

While Power BI has many customization options for visuals, it lacks the seemingly basic capability to set exact column widths in tables and matrix visuals. In Excel, you can do this to create clean, uniform reports, while in Power BI you can only adjust column widths by dragging column headers. However, I’ll show you a workaround method for doing that in this post.

What-if analysis is a technique used to understand the potential impact on outcomes by altering the inputs in a model across various scenarios. Having worked on pricing projects at multiple companies, I’ve found that it’s a widely used practice.

Imagine you’re a business owner, and you’re considering offering a discount on your products. How much revenue will you make after applying this discount? Normally, you might turn to Excel to work out these numbers. But in this article, I’ll guide you on how to do it with DAX in Power BI.