Power BI Weekly
Issue #176 - 27th September 2022
This week we've been told What’s New in the September Release of Power BI Report Server, including (amongst other updates) an updated portal and a new migration tool for uploading on-premises reports to the Power BI Service. We've been told about the On-premises data gateway September release which brings the compatibility in line with the latest Desktop version, and we've been asked to fill out the Power BI Metrics (previously referred to as Goals) survey.
Elswhere this week, Marc Lelijveld has described How OFFSET in DAX will make your life easier - OFFSET is a new (currently hidden - what is it with secret DAX formulas recently?) DAX function announced at the Power BI Next Step conference, which is one function amongst what will eventually be a group of window functions within Power BI. Do read Marc's blog for more details on what exactly OFFSET does. Also this week, James Broome has shared the third part of the Insight Discovery blog series describing the importance in Defining Actionable Insights, and Paul Waller has provided a valuable visual designer's perspective on How to enable data teams with the design assets required for impactful data storytelling in Power BI.
🛠️ Data Prep
- Chandeep Chhabra (@chandeep2786) delves into Power Query Advanced Editor Shortcuts
- On the Power BI community blog, Yan Jiang describes How to get the value in a column based on condition of another column in Power Query
- Philipp Lenz (@lenz_philipp) describes how to Use a key column for grouping in Power BI Desktop
- Laura Graham-Brown (@Laura_GB) describes Power BI & Dataverse – Choices and Choice Column
🧩 Data Modeling
- On the Power BI blog, Lucas Colusso (@lucascolusso) asks us to fill in a Power BI Metrics survey
- Darren Gosbell (@darrengosbell) announces DAX Studio v3.0.1 Released
- On the SQLBI blog, Marco Russo (@marcorus) talks about the Formula Engine – The Whiteboard #06
- On the Learning Science YouTube channel, Learning Science describes TopN in Power BI
- Marc Lelijveld (@MarcLelijveld) explains How OFFSET in DAX will make your life easier
- Bas Dohmen (@HowToPowerBI) describes how to Set Up Automatic KPI Trackers
- Sam McKay (@_EnterpriseDNA) talks about The DATEADD Function - The Best and Most Versatile Time Intelligence Function In DAX [2022 Update]
- Brian Julius (@_EnterpriseDNA) talks about Offset Magic: Make DAX Time Intelligence Disappear | Business Intelligence Summit Session 15
- Max Wikström (@maxwiks) describes how to Export your Power BI DAX measures using DAX Studio
- Hima Bindu Marri (@sivahimabindu) describes how to Format your DAX code easily
📊 Report Authoring and Interactivity
- On the endjin blog, Paul Waller (@Crashbangwaller) explains How to enable data teams with the design assets required for impactful data storytelling in Power BI
- Dhruvin Shah (@DhruvinShah16) describes how to Show Multiple X Axis Value By Hierarchy in Power BI
- On the MSSQLTips site, Harris Amjad describes How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop
- Mara Pereira (@datapears) describes How to change the colors of your visuals based on the selected measure
- Brian Julius (@_EnterpriseDNA) describes How To Create Complex Visuals In Power BI With A Single Line Of Code Using R
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes How to Visualize Python Charts in Power BI Part 4
- On the Power BI community blog, Xiaoting Yan discusses Power BI Custom Visual – Chiclet Slicer
- On the Prologika blog, Teo Lachev (@tlachev) describes Power BI Visual Help Tooltips
- Ben Gribaudo (@bgribaudo) writes about a Solved Mystery: Microsoft Gantt Chart for Power BI Rejects Some Drag and Drops
- Sam McKay (@_EnterpriseDNA) discusses Design Psychology in Data Visualization with Thomas Watkins
- Pat Mahoney (@mahoneypa) describes how to Fix Power BI report performance issues caused by too many visuals
🚀 Deployment, Security and Operations
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway September release
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Export more than 100k rows of Power BI data to CSV using Power Automate | No row limits
- Gilbert Quevauvilliers (@GilbertQue) writes about Emailing Power BI Query output as a CSV File using Power Automate
- Dan English (@denglishbi) describes Power BI using Service Principal with Synapse Data Explorer (Kusto) Pool
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes about Super Fast Data Loads to Prod
- Adam Saxton (@GuyInACube) covers Answering your questions about the new App Experience
- Nicky van Vroenhoven (@NickyvV) covers Power BI Governance & Administration – Naming Conventions [Dutch]
🌐 General
- On the Power BI blog, Cookie McCray highlights What’s New in the September Release of Power BI Report Server
- Ted Pattison (@TedPattison) announces Tune into Power BI Dev Camp Sep 29th
- On the endjin blog, Elisenda Gascon (@elisendagascon) shares 5 tips to pass the PL-300 exam: Microsoft Power BI Data Analyst