Power BI Weekly
Issue #187 - 20th December 2022
No better way to finish the year than with a feature summary for December. The window functions I mentioned in the 176th edition have now been officially released, being announced in the feature summary blog under the "Making it easier to do comparison calculations" heading. To recap, this includes three new core functions, INDEX
, OFFSET
and WINDOW
. I recommend following Jeffrey Wang's blog series Introducing DAX Window Functions to take a deeper dive into the new functionality. The other main difference in this month's Power BI Desktop release that many of you may have already noticed, is that Slicer type formatting has moved to the Format Pane. I think it makes sense, but will take some getting used to!
Elsewhere this week, the Power BI team has shared a blog taking a Deep dive into Optimize ribbon and streamline your Power BI authoring (which was released in last month's Power BI Desktop update), Christian Wade and Ogbemi Ekwejunor-Etchie have discussed the Roadmap for Semantic Models: from Azure AS to Power BI Premium, and Chris Webb has provided his opinion on the question Is Power BI A Semantic Layer?. I agree, by the way!
Finally, I'd again like to thank each and every one of you for being a subscriber to Power BI Weekly. Another year has been and gone, and what remarkable strides Power BI as a platform has made.
Happy holidays to all (where relevant!) See you in January.
🛠️ Data Prep
- Patrick Leblanc (@GuyInACube) provides A Power Query tip for you
- Imke Feldmann (@TheBIccountant) writes about Quick fix for Formula.Firewall issues in Power Query and Power BI
- On the Excelguru blog, Ken Puls (@kpuls) explains how to Convert Julian Dates to Gregorian Dates with Power Query
- James Andrew (@MatadorSoftware) explains how to Create an Index by Group in Power BI Power Query, SQL Comparison and M Code
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) covers Power Query | Calculating Hours Worked
- On the Learning Science YouTube channel, Learning Science describes How to check data quality in Power Query Using Power BI | Data Profiling in Power Query
- On the SQL Server Central blog, Ajay Kumar (@BIConsultingPr1) writes about Artificial Intelligence with Power BI
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) explains How to create a Power BI report using REST API data
🧩 Data Modeling
- Christian Wade and Ogbemi Ekwejunor-Etchie (@MSPowerBI) walk-through the Roadmap for Semantic Models: from Azure AS to Power BI Premium
- Jeffrey Wang (@jwang_pbi) covers Introducing DAX Window Functions (Part 1)
- Chris Webb (@cwebb_bi) discusses Is Power BI A Semantic Layer?
- On the SQLBI blog, Marco Russo (@marcorus) covers One-to-One Relationships – The Whiteboard #11 and on the SQLBI blog, discusses Fixing incorrect dictionary size reported by VertiPaq Analyzer
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers USERNAME, USEROBJECTID, USERPRINCIPALNAME, CUSTOMDATA, USERCULTURE – DAX Guide
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about DAX variables, virtual relationships, and iterators in Power BI
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) writes about The Importance of a Good Data Model in Power BI Desktop
- Also on the MSSQLTips site, Harris Amjad (@mssqltips) describes How to Create a Star Schema in Power BI Desktop
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) share a few blogs: Evaluate DAX Code Performance In DAX Studio, Using The Query Builder Feature In DAX Studio and Query Plan & Server Timings In DAX Studio
- Also on the Enterprise DNA blog, Harsh Anil Joshi (@EnterpriseDNA_) blogs about Power BI Ranking In Hierarchical Form
- On Acuity Training, Ben Richardson (@AcuityTraining) walks through Recreating Sum If In Power BI
- Sam McKay (@_EnterpriseDNA) talks about Extending Layered Scenario Analysis Techniques - Advanced DAX and Power BI [2022 Update] and covers Answer If Margins Are Expanding or Contracting Through Time With Power BI [2022 Update]
- Bas Dohmen (@HowToPowerBI) shares ChatGPT writes my DAX
📊 Report Authoring and Interactivity
- On the Power BI blog, Zoe Douglas (@MSPowerBI) announces Deep dive into Optimize ribbon and streamline your Power BI authoring
- On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) covers Icons In Power BI | DAX, UNICHAR, UNICODE & Custom Images and blogs about Power BI Navigation Buttons
- Meagan Longoria (@mmarie) writes about Clickable SVG images in Power BI using the HTML Content custom visual
- Adam Saxton (@GuyInACube) explains how to Build a Slicer Panel in Power BI (2022/2023)
- Leila Gharani (@LeilaGharani) covers Power BI Slicers - A Step-by-Step Tutorial for All Types to Improve Data Analysis
- Bas Dohmen (@HowToPowerBI) describes Dynamic Axis Range
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about Why dynamic colors in line charts need a different approach in Power BI
- Reid Havens (@HavensBI) talks about Easier Method for Creating On/Off (Toggle) Status Buttons in Power BI
- Brian Julius (@_EnterpriseDNA) covers Transparency Magic In Power BI With DAX
- Also on the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe Power BI Performance Analyzer Queries: An Overview
- On the Perficient blog, Arpit Malviya describes Guide to Power BI Visuals and provides A Glimpse of the Power BI Dashboard
- On the Enterprise DNA blog, Sue Bayes (@sue_bayes) covers How To Create A Parameter In Report Builder, covers How To Create & Format A Report Builder Chart and explains how to Create A Power BI Sparkline Chart In Report Builder
🚀 Deployment, Security and Operations
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Power BI Report Server: Power BI On-Premises Hosting
- Reid Havens (@HavensBI) presents Don't Panic! I'm Power BI Admin (with Kathrin Borchert)
- On the Prologika blog, Teo Lachev (@tlachev) writes about Report-enable Internal Portals with Power BI Reports
- Soheil Bakhshi (@biinsightnz) writes about Content Endorsement in Power BI, Part 2, Endorsing Contents
- On the Perficient blog, Arpit Malviya describes Row-level security (RLS) with Power BI and describes Tracking Insights with Usage Metrics In Power BI
- Dhruvin Shah (@DhruvinShah16) describes New way to Upload File from Power BI Workspace
- On the Towards Data Science blog, Saleha Shaikh (@salehas222) describes Power BI Performance Improvement Strategies Used by Professionals
🌐 General
- On the Power BI blog, Rien Hu (@MSPowerBI) announces Power BI December 2022 Feature Summary
- Miguel Félix covers Atualização Power BI Dezembro 2022 [Portuguese]
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 243 - Power BI December 2022 Feature Summary
- Yugo Shimizu (@yugoes1021) delves into [初学者へ向けて] Power BI で基本を守る大切さ と 今から学ぶ難しさについて [Japanese]