Power BI Weekly

Issue #192 - 31st January 2023

It's the week of the Power BI 2023 Wave 1 Release Plan, announcing some great upcoming features such as being able to author calculation groups in Power BI Desktop and the ability to View files from the Power BI Service within Power BI Desktop. Unfortunately, there was one feature that was teased in the notes but (sadly) quickly removed around GIT integration, though maybe there's something to look forward to there.

Elsewhere, there have been a couple of official blogs this week: Ted Pattison has described Building Multi-language Reports for Power BI in 2023, and Cookie McCray has shared the Power BI Report Server January 2023 Feature Summary, which includes the new DAX functions EVALUATEANDLOG, TOCSV and TOJSON, amongst some other new additions. From the community this week, Alex Powers has provided The (Almost) Definitive Guide to Query Folding, Ed Hansberry has described Why You Should Avoid Calculated Columns in Power BI and, just to make things interesting, Greg Deckler has countered Why You Shouldn't Avoid Calculated Columns in Power BI.

🛠️ Data Prep

Chris Webb (@cwebb_bi) walks through Passing Any Arbitrary Value From A Power BI Report To A Dynamic M Parameter
On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) provides a Power Query M Language Tutorial on Projections and blogs about Introducing Power Query Extended Date Table V2
Ben Gribaudo (@bgribaudo) describes The Flair of a Culture (or Two)
Soheil Bakhshi (@biinsightnz) covers Datatype Conversion in Power Query Affects Data Modeling in Power BI
Alex Powers (@notaboutthecell) shares The (Almost) Definitive Guide to Query Folding
On the Power BI community blog, Vijay Verma describes how to Power Query - Remove blank rows and columns and describes how to Power Query - Find Uncommon entries between two lists
Antriksh Sharma (@AntrikshShar) covers Unpivot Columns and Create Custom Groups in Power Query
Meagan Longoria (@mmarie) describes how to Unpivot a matrix with multiple fields on columns in Power Query
On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes how to Call Google Search API inside Power BI
On Acuity Training, Ben Richardson (@AcuityTraining) walks through Loading Multiple Files From A Folder Into Power BI
On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes How to Import Data in Power BI Using R
Matthew Roche (@SQLAllFather) writes about Analyzing Plex Media Server Data using Power BI

🧩 Data Modeling

On the Power BI blog, Ted Pattison (@TedPattison) announces Building Multi-language Reports for Power BI in 2023
Also on the Enterprise DNA blog, Gaelim Holland (@_EnterpriseDNA) shares Power BI Python Tutorial: How To Translate Texts
On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Power BI Data Model Optimization With VertiPaq
On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explains How to get performance data from Power BI with DAX Studio
Ed Hansberry (@ehansalytics) describes Why You Should Avoid Calculated Columns in Power BI
On the Power BI community blog, Greg Deckler (@GregDeckler) writes about Why You Shouldn't Avoid Calculated Columns in Power BI
Ignacio Barrau (@ignacho_07) covers DATEADD vs PARALLELPERIOD [Spanish]
On the Prologika blog, Teo Lachev (@tlachev) blogs about Implementing “Generic” Percent of Grand Total in DAX
Sam McKay (@_EnterpriseDNA) describes How To Create Dynamic Tables In Power BI Using RANKX [2023 Update]
Reid Havens (@HavensBI) talks about Inside Bravo for Power BI (with Marco Russo)
Antriksh Sharma (@AntrikshShar) explains how to Create SSAS Tabular and Power BI Dataset with Python from Model.bim
Bernat Agulló Roselló (@AgulloBernat) describes Dynamic headers in Power BI, sort of.
On the Select Distinct blog, Select Distinct (@SelectDistLtd) explains How to sort dates in Power BI

📊 Report Authoring and Interactivity

Also on the Enterprise DNA blog, George Mount (@_EnterpriseDNA) explains how to Create A Histogram Using The R Visual In Power BI
Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) explains how to Create A Gantt Chart In Power BI Report Builder
On the MSSQLTips site, Harris Amjad (@mssqltips) explains how to Create and Format a Bullet Chart in Power BI
Sam McKay (@_EnterpriseDNA) discusses Considerations For Dark Backgrounds In Power BI Reports [2023 Update]
Gaurav Mahajan talks about Power BI Storytelling

🚀 Deployment, Security and Operations

On the RADACAD blog, Reza Rad (@Rad_Reza) covers Power BI Publish to Web – Questions Answered and writes about What Is the XMLA Endpoint for Power BI and Why Should I Care?
Patrick Leblanc (@GuyInACube) discusses What happens when you miss a refresh day with Power BI Incremental Refresh?
On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) explains how to Deploy a Power BI dataset via a DevOps - Setup, explains how to Deploy a Power BI dataset via a DevOps - Build and explains how to Deploy a Power BI dataset via a DevOps - Publish
On the SQL Server Central blog, Steve Jones (@way0utwest) walks through Publishing a Public Power BI Report from Google Sheets
On the Prologika blog, Teo Lachev (@tlachev) writes about Solving iPad Issues with Power BI Secure Embed
On the Enterprise DNA blog, Henry Habib (@_EnterpriseDNA) describes Power BI Tile | How To Integrate Into Power Apps
Just Blindbæk (@justblindbaek) delves into Query Power BI activity events with Synapse Serverless SQL
Ruth Pozuelo Martinez (@CurbalEN) describes how to Export data from Power BI service to Excel as a table
Audrée Pellerin (@lecfomasque) covers Cas complexe de rôles RLS dans Power BI [French]

🌐 General

On the Power BI blog, Cookie McCray (@MSPowerBI) announces Power BI Report Server January 2023 Feature Summary
Chris Webb (@cwebb_bi) lists the Top 10 Reasons Why Power BI People Should Attend SQLBits
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 247 - Interview with Scott Sewell and present Episode 248 - Power BI 2023 release wave 1 plan
On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) covers Power BI Tips And Tricks For Your Reports
Lars Schreiber (@SchreiberLars) covers Den Personaleinsatz mit Power BI reporten [German]