Power BI Weekly Newsletter Issue #112

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

• Soheil Bakhshi (@biinsightnz) writes about Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop
• On the Power BI community blog, Kumail covers Query Folding in PowerBI
• Also on the Power BI community blog, Yingjie Li talks about Json Transformations
• On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) covers Unpivot in Power Query
• Bas Dohmen (@HowToPowerBI) talks about Conditional JOIN using Power Query A different way of merging in Power BI
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes Showing Ranking in a Visual in Power BI using RANKX DAX function and describes how to Document a Power BI file and report in a few clicks all DAX code visualization Power Query scripts
• Melissa de Korte (@_EnterpriseDNA) talks about a Perpetual Holiday Calendar In Power BI - Power Query Solution
• Bas Dohmen (@HowToPowerBI) describes Showing last refresh in Power BI

Data Modeling

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

• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Understanding eager vs. strict evaluation in DAX, describes DATE, TIME – DAX Guide and covers DATEDIFF, YEARFRAC – DAX Guide
• Marco Russo (@marcorus) talks about Optimizing the distribution of distance between transactions - #Unplugged 21
• Philipp Lenz (@lenz_philipp) writes about Why should you create explicit measures?
• Spencer Baucke (@JSBaucke) explains How to Create YTD Calculations in Power BI and covers The CALCULATE Function in Power BI
• On the Towards Data Science blog, Nikola Ilic (@DataMozart) explains How to Create a Rating Visual in Power BI using DAX
• Chandeep Chhabra (@chandeep2786) explains how to Calculate Growth over Previous Quarter End Month – DAX Challenge
• Reid Havens (@HavensBI) describes Adding Dynamic Multi Value Data Labels to Visuals with Kane Snyder and describes How the Microsoft Power BI Team Evolves the Platform with Will Thompson
• Hima Bindu Marri (@sivahimabindu) describes How to fix Blank value in slicers in Power BI
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about the TOPN DAX Function - How it works in Power BI - Comparison against the top group
• Also on the Enterprise DNA blog, Paul Lucassen blogs about a Distance And Bearing Calculation: Power BI Geospatial Analysis and talks about Center Of Gravity Analysis In Power BI
• On the Enterprise DNA blog, Nick Mone discusses the VertiPaq Engine In Power BI – Usage & Best Practices, writes about the VertiPaq Analyzer In DAX Studio and shares a VertiPaq Analyzer Tutorial: Relationships & Referential Integrity
• Also on the Towards Data Science blog, Peter Hui writes about Power BI Modelling

Report Authoring and Interactivity

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

• On the Power BI blog, Amanda Rivera (@MissAmandaN) describes how to Quickly create reports from SharePoint lists and provides the Power BI Report Server May 2021 Feature Summary
• Also on the Power BI blog, Amit Shuster (@ShusterAmit) announces Power BI in Jupyter notebooks
• On the Power BI community blog, David Edelman describes Creating a Visual Calendar in Power BI
• Patrick Leblanc (@GuyInACube) presents Exploring anomaly detection in Power BI and a sneak peak (with Justyna Lucznik)
• Adam Saxton (@GuyInACube) talks about 3+ approaches for Dynamic Axis in Power BI
• Jarrett Moore (@BuckeyeJarrett) describes Using Charticulator To Conditionally Highlight Bar Chart
• Chandeep Chhabra (@chandeep2786) talks about a Fiscal Year Date Table in Power BI
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes how to Export the Data of a Power BI table entirely in a few Clicks
• Matt Allington (@ExceleratorBI) explains how to Build a P&L in Power BI Without Any DAX
• Dhruvin Shah (@DhruvinShah16) talks about Quick Edit Power BI Paginated Report from Power BI Service and describes how to Quickly create Power BI Report from SharePoint List or Microsoft List
• Belinda Allen (@MsBelindaAllen) talks about More Matrix visual formatting in Microsoft Power BI

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, Nimrod Shalit describes how to Automate deployments with deployment pipelines API (preview)
• Sujata Narayana demonstrates Easy report sharing using links in Microsoft Power BI
• Matthew Roche (@SQLAllFather) blogs about Data Governance and Self-Service Business Intelligence

General

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

• Also on the Power BI blog, Arun Ulag (@arunulag) talks about Enabling intelligent experiences with Power BI for developers, data scientists, and data engineers
• On the Power BI blog, Lukasz Pawlowski (@lukasztweets) writes Announcing: Now its easier to find Power BI reports in Microsoft Teams tabs
• Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays! #210: Is the end of DAX coding near? - Microsoft Build announcements for Power BI
• Dhruvin Shah (@DhruvinShah16) talks about Microsoft Build 2021 - Power BI Announcements
• Rutuja Shivraj Pawar writes about T-profile in Power BI
• Gil Raviv (@gilra) updates the Bitcoin Calculator in Power BI
• Daniil Maslyuk (@DMaslyuk) highlights that Microsoft Exam Ref DA-100 is now available
• Gregory Petrossian (@gregpetrossian) writes about Business Intelligence Tools: A Pros and Cons Comparison Chart
• Reid Havens (@HavensBI) describes How the Microsoft Power BI Team Evolves the Platform with Will Thompson
• Adam Saxton and Patrick Leblanc (@GuyInACube) share Power BI tips from the Pros – LIVE w/ Kasper de Jonge (May 29, 2021)
• Mara Pereira (@datapears) writes about My views on Power BI core skills

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.