Power BI Weekly
Issue #291 - 14th January 2025
No official Power BI blogs yet, so let's dive into the community articles. To start, Eugene Meidinger has written a thought-provoking piece on How Power BI Dogma Leads to a Lack of Understanding, highlighting that "best practices" are just a set of guiding principles (and how sometimes it's OK (or even necessary) to break said practices), and how being overly dogmatic can negatively influence your and others' learning. Very interesting read. Elsewhere this week, Andy Forrester has described how to Import Microsoft Project Data into Power BI Using Python (avoiding manual importing of Excel files), Ioannis Doganos has provided an end-to-end example about How I automated a monthly PowerPoint presentation using Power BI, and Lasse Malo has told us to Forget The Publish Button In Power BI Desktop Ever Existed, walking through the OneDrive/SharePoint integration for pbix files which allows for automatic syncing of your report into the Power BI Service (a feature we use heavily here at endjin!).
🛠️ Data Prep
- Laura Graham-Brown (@Laura_GB) writes about Power Query – Creating New Parameter Made Easier and Power Query – Fixing Missing Columns Dynamically
- On the SQL Server Central blog, John Kerski (@JKerski) describes Comparing Groups for Similarities in Power Query – Using Cosine Similarity
- Chandeep Chhabra (@chandeep2786) presents Getting Started with {M} in Power Query | Live Event
- Sunil Mathew (@_sunil_mathew_) describes how to Dynamically Switch Data source (Excel to SQL) with Power Query Parameters | Power BI Tutorials
- Shivanshu Bisht describes how to Combine Multiple Google Sheets in Power Query
- Andy Forrester describes Importing Microsoft Project Data into Power BI Using Python
🧩 Data Modeling
- On the Power BI community blog, Tharun Kumar Ravikrindhi discusses SVG based Power BI semantic model columns and measures are great but there is a problem
- ,, Parul Sagar (@parulsagar) writes about Statistical Insights Using CHISQ.DIST in Power BI DAX
📊 Report Authoring and Interactivity
- On the Business Intelligist blog, Nikil Prabhakar covers Unlocking the Power of Field Parameters in Power BI
- On the Power BI community blog, Anmol Malviya explains how to Manage Large Datasets More Efficiently with Power BI’s New Data Limit Feature
- Reid Havens (@HavensBI) talks about Waterfall Charts with Categories (and Considerations...)
- Bas Dohmen (@HowToPowerBI) explains how to Build this unique chart with me | Power BI
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) explains How to add more than two data labels to Columns, Bars, Lines, and Ribbon charts in Power BI?
- Audrée Pellerin (@lecfomasque) covers Intelligence artificielle dans Power BI : Visuels [French]
🚀 Deployment, Security and Operations
- On the Microsoft Fabric Café YouTube channel, Reid Havens (@HavensBI) describes how to Avoid Data Silos | Best Practices for Implementing Shared Semantic Models
- Chris Webb (@cwebb_bi) writes about Changing The Source Lakehouse Of Power BI Direct Lake Models In Deployment Pipelines
- Mimoune Djouallah (@mim_djo) writes about Fabric for Small Enterprises
- Lasse Malo writes Forget The Publish Button In Power BI Desktop Ever Existed
🌐 General
- Eugene Meidinger (@sqlgene) discusses How Power BI Dogma Leads to a Lack of Understanding
- On the RADACAD blog, Reza Rad (@RADACAD_COM) talks about Where to Start Microsoft Fabric as a Power BI Developer
- Ioannis Doganos describes How I automated a monthly PowerPoint presentation using Power BI