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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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]
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.