Power BI Weekly Newsletter Issue #114

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• 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

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• 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

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• 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

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling

• 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

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

• 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

Useful Links

• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
• Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
• Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.