Power BI Weekly Newsletter Issue #157

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

• Imke Feldmann (@TheBIccountant) explains how to Create (empty) table string from schema in Power Query
• Hima Bindu Marri (@sivahimabindu) covers Query folding in Power BI Part 1
• On the Power BI community blog, Vijay Verma describes how to Test for a Number in Power Query M Language
• James Serra (@JamesSerra) blogs about Power BI connectors to Azure Synapse
• On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) describes how to Import data using Python in Power BI

Data Modeling

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

• On the endjin blog, Jessica Hill describes Table Functions in DAX: FILTER and ALL
• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Understanding context transition, describes PERMUT – DAX Guide and discusses DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD – DAX Guide
• Bas Dohmen (@HowToPowerBI) shares a few videos: Filter Context & CALCULATE | DAX Essentials 1, Row Context & Iterators | DAX Essentials 2 and Context Transition | DAX Essentials 3
• Patrick Leblanc (@GuyInACube) talks about Why isn't my Agg hitting when using DISTINCTCOUNT in Power BI?
• On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) covers Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX and talks about Using DataTable DAX Function for Creating Structured Table in Power BI
• On the Learning Science YouTube channel, Learning Science describes Virtual Table and SUMMARIZE Function in Power BI
• Avi Singh (@powerbipro) discusses Power BI: Year to Date Comparison for Current vs. Prior Year
• On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about Three things you need to know when using Variables in DAX
• Jing Zhang describes how to Group your data according to dynamic measure results
• Reid Havens (@HavensBI) shares DAX Anti-Patterns Episode Nine - Filter Columns Not Tables! (Part 1) - with Daniil Maslyuk
• Also on the Towards Data Science blog, Nikola Ilic (@DataMozart) writes In the Power BI whirlpool — understanding circular dependencies

Report Authoring and Interactivity

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

• On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) announces the SandDance Power BI Custom Visual updates
• On the Power GI blog, Danni Olson covers Story Telling with PowerBI
• James Andrew describes Using Power BI Template Files for Great Data Visualization
• Gilbert Quevauvilliers (@GilbertQue) shares a Known Issues Power BI Report with Alerting
• On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) provides a Power BI Report Builder Introduction
• On the MSSQLTips site, Scott Murray describes Power BI Desktop - What is it and how do I use it?
• Michael Felix describes Algumas funcionalidades [Portuguese]
• James Andrew describes Essential Keyboard Shortcuts in Power BI Desktop | #shorts #data

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, Roy Rubinstein announces the New Power BI Known Issue page
• Patrick Leblanc (@GuyInACube) describes How do you share your Power BI Dataset for someone to review?
• Reid Havens (@HavensBI) discusses Let Me Sell You on Power BI Goals (with Tommy Puglia)

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, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI May 2022 Feature Summary
• Also on the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the Action bar for interactive reports in the Power BI tab for Microsoft Teams
• On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 224 - Power BI April 2022 Feature Summary
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) presents Live Power BI Q&A with RADACAD - 2022-05-13
• Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show Ep 4 - Incremental Refresh, Hybrid Tables, and Charticulator
• Ignacio Barrau (@ignacho_07) announces Data Quality Report - Power BI external tool [Spanish]
• On the Power BI community blog, Ted Pattison (@TedPattison) announces Deep Dive into Power Query and M Programming at Power BI Dev Camp

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.