Power BI Weekly

Issue #114 - 15th June 2021

A number of updates this week: you can now Analyze your personal activity in Microsoft Teams with Power BI showing information about your meetings amongst other things (perfect proof that you're probably spending too much time in meetings!) It's now also possible to Embed Power BI in Salesforce, with the team providing some nice Developer samples to help us on our way. Talking about developer samples - there are some New developer samples for update data sources and encrypt credentials in .NET Core, Java and Python. I've previously shown how to do this for an on-prem data source using PowerShell, if you're more comfortable in PowerShell. Finally, it's been highlighted that the On-premises data gateway June 2021 update is now available.

Elsewhere this week, Chris Webb has discussed What The New Visio Web App And Licensing Announcement Means For Power BI (it's good news), Daniil Maslyuk has written a succinct comparison of Power Query in dataflows vs. datasets, and Matt Allington has discussed 5 Productivity Benefits of Tabular Editor 3.

🛠️ Data Prep

Chris Webb (@cwebb_bi) describes how to Speed Up Power Query In Power BI Desktop By Increasing Or Decreasing The Number Of Evaluation Containers
Daniil Maslyuk (@DMaslyuk) discusses Power Query in dataflows vs. datasets
On the Power BI community blog, Eason Fang describes How to extract values of date/currency amount from text strings in Power query
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Low-Code Data Quality Automation using Power Query - with Gil Raviv, and shares numerous other videos: Extract Parts of a Text Value in Power BI using a Delimiter Power Query Transformation, Split Column by Delimiter in Power BI and Power Query and Create a Table in Power BI using Enter Data and How to Edit it
Also on the RADACAD YouTube channel, Leila Etaati (@leila_etaati) explains how to Add Column By example in Power Query and shares Power BI live stream data with Power Automate (Part Two)
Laura Graham-Brown (@Laura_GB) talks about Power Query – Get Previous Row Data
On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes Solved! Query folding for native SQL in Power BI
Bas Dohmen (@HowToPowerBI) describes how to Dynamically Remove All Empty Columns with some M MAGIC in Power BI
Chandeep Chhabra (@chandeep2786) describes how to Unpivot Cross Tabulated Data with Multiple Headers and Columns

🧩 Data Modeling

Matt Allington (@ExceleratorBI) writes about 5 Productivity Benefits of Tabular Editor 3
Adam Saxton and Patrick Leblanc (@GuyInACube) presents Tabular Editor 3 & Power BI Q&A – LIVE w/ Daniel Otykier & Marco Russo
Adam Saxton (@GuyInACube) walks through Tracing your DAX queries in Power BI
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares: DATEVALUE, TIMEVALUE – DAX Guide, NOW, TODAY, UTCNOW, UTCTODAY – DAX Guide and describes All the secrets of SUMMARIZE
Also on the SQLBI blog, Marco Russo (@marcorus) explains the wait time when you open a Power BI file – Unplugged #23
On the Enterprise DNA blog, Nick Mone writes about the Storage Engine In Power BI – VertiPaq Operators & Queries and covers GroupBy In Power BI: An Implied Function In VertiPaq
Rick de Groot (@Rickmaurinus) covers Understanding Evaluation Context in DAX
On the Towards Data Science blog, Salvatore Cagliari blogs about Refinement of Semi-Additive Measures in DAX
Chandeep Chhabra (@chandeep2786) writes about Related and RelatedTable in DAX
Ruth Pozuelo Martinez (@CurbalEN) talks about DAX Fridays #211: Using inactive relationships in slicers | USERELATIONSHIP
Hima Bindu Marri (@sivahimabindu) talks about LookupValue in Powe BI
Brian Julius describes How To Fix Matrix Totals In Power BI
Sam McKay (@_EnterpriseDNA) describes How To Cumulatively Compare A Best Month Results To The Current Month Using DAX
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains how to Get a field value from a related table in Power BI DAX RELATED Function Explained
On the Power BI community blog, Ignacio Barrau (@ignacho_07) writes about [DAX] Visualize last N months picking only one from filter context
On the Prologika blog, Teo Lachev (@tlachev) writes about Power BI Aggregations: Limitations and Workarounds

📊 Report Authoring and Interactivity

On the Power BI blog, Amit Shuster (@ShusterAmit) explains how to Embed Power BI in Salesforce
Chris Webb (@cwebb_bi) writes about What The New Visio Web App And Licensing Announcement Means For Power BI
On the Enterprise DNA blog, Mudassir Ali talks about Custom Visual Reports In Power BI and writes about Visual Reports Without Advanced DAX Skills In Power BI
Adam Saxton (@GuyInACube) talks about the Do’s and Don’t with cascading slicers in Power BI
Ruth Pozuelo Martinez (@CurbalEN) describes how to Conditional format a line chart in Power BI
Reid Havens (@HavensBI) describes how to Conditionally Show/Hide Matrix Columns Using Calculation Groups
The Power BI team (@MSPowerBI) talks about the Modern visual tooltips in Microsoft Power BI
On the Burningsuit blog, Alison Box blogs about Charticulator In Power BI 2. and Charticulator In Power BI 3.

🚀 Deployment, Security and Operations

On the Power BI blog, Amit Shuster (@ShusterAmit) writes about the New developer samples for update data sources and encrypt credentials
Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that the On-premises data gateway June 2021 update is now available
The Power BI team (@MSPowerBI) talks about the New enhancements in Power BI app for Teams
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes how to Export Power BI Audit log in a few Simple Steps with No Code
Matthew Roche (@SQLAllFather) reminds us to Never underestimate the voice of the customer
On the Marquee Insights blog, Treb Gatte (@tgatte) blogs: Power BI Goals Introduction, Part 3

🌐 General

On the Power BI blog, Patrick Baumgartner (@patbaum) explains how to Analyze your personal activity in Microsoft Teams with Power BI
Dhruvin Shah (@DhruvinShah16) talks about the announcement: Analyze your Personal Activity in Microsoft Teams with Power BI
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 194 - Interview with Andrew Brust
Reid Havens (@HavensBI) explains how to Identify, Build & Represent Your Power BI Skills with Seth Bauer
Matthew Roche (@SQLAllFather) shares the Free Power BI Intro Training From Microsoft