Power BI Weekly
Issue #113 - 8th June 2021
A few announcements this week. A lesser known tool has been given a spruce-up, that is the Power BI Windows app, which is a desktop app designed for a consumption experience and provides, for example, an "offline" mode of viewing reports. We've also been told What's new in the June update of Power BI Report Builder, and there is now support for email notifications for non-owners of dataflows, to add to the non-owner table view support added in April.
Elsewhere this week, Alberto Ferrari has discussed an often confusing topic around optimization within DAX, and that's Auto-exist on clusters or numbers. Paul Turley has shared a video (with an accompanying blog) talking to various Power BI colleagues around Designing and Managing Large Datasets, discussing the factors to consider and various options and preferences of how to handle them. Finally, John White has shared some First impressions of the new “Visualize in Power BI” feature for SharePoint Lists, describing the good and the bad for the new feature designed to decrease the time-to-insights for those working with data in SharePoint lists.
🛠️ Data Prep
- Matthew Roche (@SQLAllFather) shares Roche’s Maxim of Data Transformation
- Chris Webb (@cwebb_bi) describes how to Speed Up Power Query In Power BI Desktop By Allocating More Memory To Evaluation Containers
- Gil Raviv (@gilra) shares a New Recording: Power Query at Italy PUG
- Kristian Radoš discusses Merging with date range using Power Query
- On the Power BI Community blog, Robert Qin describes How to fuzzy match the dirty data and horizontal display the corresponding table
- Lars Schreiber (@SchreiberLars) writes Meine projekterprobte Kalendertabelle für Power BI und Power Pivot [German]
- Cathy Monier writes about Power Query – Fonctions de calendrier réutilisables [French]
- Also on Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes Année fiscale vs Année calendrier [French], Calendrier 4-4-5 [French] and Créer des segments temporels performants dans Power BI [French]
- On the CSG Pro blog, Sandeep Pawar (@PawarBI) provides an Intro to AutoML in Power BI Premium
- Reid Havens (@HavensBI) covers Pro User Excel Add-In - MonkeyTools (with Ken Puls)
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) talks about Power BI and Microsoft form, Streaming Dataset (Part One)
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) writes about Auto-exist on clusters or numbers – Unplugged #22
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares Date and time parts – DAX Guide, EDATE, EOMONTH – DAX Guide and DATEVALUE, TIMEVALUE – DAX Guide
- Gilbert Quevauvilliers (@GilbertQue) writes about Scalability – Part 2 Migrating AAS to PPU
- Also on the SQLBI blog, Marco Russo (@marcorus) discusses Setting the right permissions for users of composite models
- Paul Turley (@paul_turley) blogs about Doing Power BI the Right Way: 10. Designing and Managing Large Datasets
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) shares a few videos: Month over Month Calculation in Power BI using DAX, How to Reduce the Size of Power BI file in a few Steps, FILTER Function in DAX and Power BI Apply Custom Filter to Calculations and Document the Power BI Tenant objects: Workspace, reports, datasets, dataflows with no code
- On the Enterprise DNA blog, Nick Mone writes about DAX Query Structure In Power BI – Two Engines & DAX Studio and blogs about DAX Query In Power BI – Logical & Physical Query Plans
- Also on the Enterprise DNA blog, Paul Lucassen writes about a Distance Calculation On Map | Power BI Geospatial Analysis
- Antriksh Sharma explains How To Travel Back In Time Using DAX
- Matthew Peterson (@mattpetersonbi) covers Power BI: Understand Filter Context and CALCULATE
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays! #210: Allocation calculations grouped by period | GROUPBY , CURRENTGROUP
- Hima Bindu Marri (@sivahimabindu) describes Measure tables in Power BI
- Dhruvin Shah (@DhruvinShah16) writes about the IF EAGER DAX function in Power BI
- Brian Julius describes Controlling Totals and Subtotals In Power BI
📊 Report Authoring and Interactivity
- On the Power BI blog, Michael Bruhjell blogs about What's new in the June update of Power BI Report Builder
- Also on the Power BI blog, Maya Shenhav writes that the Power BI Windows app has new look (preview)!
- Philipp Lenz (@lenz_philipp) describes How to make a Power BI report more useful for your users?
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) describes How To Use Animated GIFs in Power BI
- On the Power BI community blog, Pragati Jain writes about the Modern Visual Tooltip in Power BI
- On the Burningsuit blog, Alison Box writes about Charticulator in Power BI #1
- Reid Havens (@HavensBI) talks about Charticulator: Now a Power BI Custom Visual! (with Daniel Marsh-Patrick)
- Dhruvin Shah (@DhruvinShah16) writes about All you should know about Power Automate Visual in Power BI
- The Power BI team (@MSPowerBI) describes the New and improved shapes and more in Microsoft Power BI
- John White (@diverdown1964) describes the First impressions of the new “Visualize in Power BI” feature for SharePoint Lists
- On the MSSQLTips site, Hristo Hristov discusses a Power BI Comments Form with Power Apps
- On the BlueGranite YouTube channel, Dawn Clement talks about Power BI and Power Automate for Higher Education
- Greg Philps describes How To Simulate Dynamic Theming In Power BI Reports
🚀 Deployment, Security and Operations
- On the Power BI blog, Charles Webb (@CharlesWebb22) announces email notifications for non-owners of dataflows
- Brett Powell (@BrettPowell76) blogs about Breaking Changes in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Automatically alert your data source owners to update their sources
- On the MSSQLTips site, Kenneth A. Omorodion explains how to Notify Users of Power BI Dataset Changes
- Parker Stevens (@PowerBIElite) explains how to Refresh All Datasets from Power BI Desktop with 1 Click
- The Power BI team (@MSPowerBI) explains how to Explore the new dataset discovery hub in Microsoft PowerBI
- Marc Lelijveld (@MarcLelijveld) explains how to Integrate Power BI Deployment Pipelines with Azure DevOps
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Seguridad de filas (RLS) con regla dinámica [Spanish]
🌐 General
- Gil Raviv (@gilra) provides A Mailchimp Power BI App
- The Knee-Deep in Tech team (@KneeDeepinTech) shares Podcast episode 153
- John White and Jason Himmelstein (@bifocalshow) present Episode 193 - Interview with Laura Graham-Brown