Azure Weekly - Power BI Weekly #157 - 17th May 2022
Power BI Weekly Newsletter Issue #157
powered by endjin
Welcome to the 157th edition of Power BI Weekly! Yesterday the Power BI May 2022 Feature Summary came out, and the feature that's drawn the most attention (quite rightly) has been the introduction of Field parameters, for a much more seamless way of allowing users to dynamically change the measures/fields shown on a chart. Other news this week includes the new ability for tenant admins to disable DirectQuery against Power BI Datasets (although I do sympathize if your tenant admin decides to do this), and that the Charticulator visual is now GA. We've also been told about some SandDance Power BI Custom Visual updates, the new Action bar for interactive reports in the Power BI tab for Microsoft Teams and the New Power BI Known Issue page. On that last point, Gilbert Quevauvilliers has created and demonstrated a helpful Known Issues Power BI Report with Alerting.
Elsewhere this week, James Serra has broken down the various Power BI connectors to Azure Synapse, Jess Hill has written about Table Functions in DAX: FILTER and ALL, and Ignacio Barrau has shared a new external tool which generates a handy Data Quality Report over an existing data model.
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.
Tweet | Forward | Preferences | Unsubscribe
Older messages
Power BI Weekly #156 - 10th May 2022
Tuesday, May 10, 2022
Power BI Weekly Newsletter Issue #156 powered by endjin Welcome to the 156th edition of Power BI Weekly! This week we've been told about the New data source and gateway management experience (which
☁️ Azure Weekly #370 - 8th May 2022
Sunday, May 8, 2022
Azure Weekly Newsletter Issue #370 powered by endjin Welcome to issue 370 of Azure Weekly. A relatively quite week, perhaps the calm before the storm that is the Microsoft BUILD conference later this
Power BI Weekly #155 - 3rd May 2022
Tuesday, May 3, 2022
Power BI Weekly Newsletter Issue #155 powered by endjin Welcome to the 155th edition of Power BI Weekly! Some really cool news is that Analyze in Excel Workbooks are now saved to OneDrive for Business,
☁️ Azure Weekly #368 - 24th April 2022
Sunday, April 24, 2022
Azure Weekly Newsletter Issue #368 powered by endjin Welcome to Issue 268 of Azure Weekly. It's a bumper issue as I was on holiday last week. One of the biggest announcements over the last two
☁️ Azure Weekly #367 - 10th April 2022
Sunday, April 10, 2022
Azure Weekly Newsletter Issue #367 powered by endjin Welcome to issue 367 of Azure Weekly! The big news this week is that Azure Virtual Machines with Ampere Altra ARM-based processors are now in
You Might Also Like
Import AI 399: 1,000 samples to make a reasoning model; DeepSeek proliferation; Apple's self-driving car simulator
Friday, February 14, 2025
What came before the golem? ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Defining Your Paranoia Level: Navigating Change Without the Overkill
Friday, February 14, 2025
We've all been there: trying to learn something new, only to find our old habits holding us back. We discussed today how our gut feelings about solving problems can sometimes be our own worst enemy
5 ways AI can help with taxes 🪄
Friday, February 14, 2025
Remotely control an iPhone; 💸 50+ early Presidents' Day deals -- ZDNET ZDNET Tech Today - US February 10, 2025 5 ways AI can help you with your taxes (and what not to use it for) 5 ways AI can help
Recurring Automations + Secret Updates
Friday, February 14, 2025
Smarter automations, better templates, and hidden updates to explore 👀 ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
The First Provable AI-Proof Game: Introducing Butterfly Wings 4
Friday, February 14, 2025
Top Tech Content sent at Noon! Boost Your Article on HackerNoon for $159.99! Read this email in your browser How are you, @newsletterest1? undefined The Market Today #01 Instagram (Meta) 714.52 -0.32%
GCP Newsletter #437
Friday, February 14, 2025
Welcome to issue #437 February 10th, 2025 News BigQuery Cloud Marketplace Official Blog Partners BigQuery datasets now available on Google Cloud Marketplace - Google Cloud Marketplace now offers
Charted | The 1%'s Share of U.S. Wealth Over Time (1989-2024) 💰
Friday, February 14, 2025
Discover how the share of US wealth held by the top 1% has evolved from 1989 to 2024 in this infographic. View Online | Subscribe | Download Our App Download our app to see thousands of new charts from
The Great Social Media Diaspora & Tapestry is here
Friday, February 14, 2025
Apple introduces new app called 'Apple Invites', The Iconfactory launches Tapestry, beyond the traditional portfolio, and more in this week's issue of Creativerly. Creativerly The Great
Daily Coding Problem: Problem #1689 [Medium]
Friday, February 14, 2025
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. Given a linked list, sort it in O(n log n) time and constant space. For example,
📧 Stop Conflating CQRS and MediatR
Friday, February 14, 2025
Stop Conflating CQRS and MediatR Read on: my website / Read time: 4 minutes The .NET Weekly is brought to you by: Step right up to the Generative AI Use Cases Repository! See how MongoDB powers your