Power BI Weekly
Issue #233 - 14th November 2023
This week the ground-breaking news is that Datasets have been renamed to semantic models. I should think this decision will divide opinion. From the Fabric perspective, this makes total sense. There are too many artifacts that resemble "datasets" in Fabric such that the term could add an annoying level of ambiguity (especially for newcomers). Conversely, looking at Power BI in isolation, "datasets" are a well-defined artifact type and can't be confused as easily with other artifacts. "Dataset" is also a well-known and understood term. "Semantic model" is less well understood as a term, but I do think it more accurately describes the role of the data model + measures in Power BI. Anyway, it will be interesting to see how the community reacts to this one!
There has been one other announcement this week, and that's the On-premises data gateway November 2023 release, which includes a new tenant registration allowlist setting which you can use to control which tenants are allowed to register the on-premises data gateway application. The final article I'd like to highlight this week has been written by my colleague Barry who has written about why Star Schemas are fundamental to unleashing value from data in Power BI and Microsoft Fabric, focusing on the business and end-user implications/justifications rather than solely the technical, and discussing where in the data pipeline lifecycle the star schema should be generated. Do have a read!
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about Excel Workbook Layout And The Performance Of Reading Data With Power Query In Power BI
- Chandeep Chhabra (@chandeep2786) describes how to Dynamically Expand All Columns in Power Query | Power Query Trick and covers '#section' Trick in Power Query
- Rick de Groot (@Rickmaurinus) writes about Resolving Dataformat Errors in Power Query M
- Avi Singh (@powerbipro) shares a Power Query Tutorial for Beginners: Complete Step-by-Step Tutorial with Download Files
- On the Learning Science YouTube channel, Learning Science explains How to get SharePoint data into Power BI?
🧩 Data Modeling
- On the Power BI blog, Christian Wade (@_christianWade) announces Datasets renamed to semantic models
- On the endjin blog, Barry Smart (@barry_j_a_smart) writes that Star Schemas are fundamental to unleashing value from data in Microsoft Fabric
- On the SQLBI blog, Marco Russo (@marcorus) discusses Computing MTD, QTD, YTD in Power BI for the current period
- Chandeep Chhabra (@chandeep2786) talks about DAX Summarization Tricks in Power BI
📊 Report Authoring and Interactivity
- Tom Martens (@tommartens68) writes about The (better) rectangular pie chart
- Bas Dohmen (@HowToPowerBI) talks about Why Your Report Needs a Box Plot and How to Build It in Power BI
- Reid Havens (@HavensBI) talks about Three Techniques for Curating the User Experience in Power BI
- Marcus Wegener (@PowerBIler) describes Display images from Business Central via the API in Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway November 2023 release
- On the phData blog, Gavin Pedersen (@gavin_PD) describes How to Automate Switching Your Snowflake Datasource with Power BI Deployment Pipelines
- Kevin Chant (@kevchant) blogs about Power BI Project (PBIP) and Azure DevOps CI performance tests
🌐 General
- The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 244
- On the Power BI community blog, Dennis Carriere writes about From the Desk of An Experienced Power BI Analyst
- On the PowerPivotPro blog, Rob Collie (@robcolli3) covers Tableau VS Power BI and writes about Why Is Power BI More Popular than Tableau?