Power BI Weekly
Issue #108 - 4th May 2021
Quite a lot going on this week. Firstly, don't forget the MBAS summit later on today, where you can hear about the amazing Power BI customer stories sessions,, see some demos, and get up to date with the Power BI roadmap. Otherwise this week, we've been provided a Premium Gen 2 timeline update – Capacity size enforcement and autoscale charges coming up - if you're using Gen2 make sure you take a note of the key dates specified in that blog. Chris Finlan has also shared a video of the New way to enable Power BI Premium for your workspaces and apps which some of you may have noticed while going to your workspace settings. We've also been told that the On-premises data gateway April 2021 update is now available.
Elsewhere this week, Marco Russo and Amir Netz have written a brief blog highlighting the Community and third-party tools for developing enterprise-level Power BI and Analysis Services models, referencing a blog from the SQLBI team (also included in this newsletter), and Phil Seamark has described a nice way to Pause/Resume calculations with Apply All feature in a Power BI report.
🛠️ Data Prep
- Ruth Pozuelo Martinez (@CurbalEN) shares some Best tips when working with Power BI dataflows
- Bas Dohmen (@HowToPowerBI) delves into CUSTOM M FUNCTIONS in Power BI
- John White (@diverdown1964) describes Using Power BI with Microsoft Lists
- On the Power BI community blog, v-lionel-msft describes how to Selectively Importing Python Tables and Auto Exporting with Python
- On the Blue Granite blog, Tom Weinandy (@TomWeinandy) describes The Ultimate List of AI Features in Power BI
🧩 Data Modeling
- On the Power BI blog, Christian Wade (@_christianWade) blogs about Community and third-party tools for developing enterprise-level Power BI and Analysis Services models
- Chris Webb (@cwebb_bi) describes Measuring DirectQuery Performance In Power BI
- Phil Seamark (@PhilSeamark) talks about Power BI – Pause/Resume calculations with Apply All feature
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: SELECTEDVALUE – DAX Guide, CALCULATE, CALCULATETABLE – DAX Guide, ALL, ALLNOBLANKROW – DAX Guide and FILTER – DAX Guide
- Also on the SQLBI blog, Marco Russo & Alberto Ferrari writes about When to use KEEPFILTERS over iterators, Marco Russo covers the Development tools for Tabular models in 2021 and explains unexpected results with DAX Time Intelligence functions – Unplugged #17
- Brian Grant (@BrianGrantBI) says that Tabular Editor 3 Will Change The Way You Power BI
- On the Towards Data Science blog, Salvatore Cagliari writes about A DAX drama in 3 acts with two time dimensions
- On the Burningsuit blog, Alison Box writes about Why You Should Never Assume Your DAX Code is Correct; Taking a Closer Look at Bi-Directional Filtering
- Chandeep Chhabra (@chandeep2786) shares some DAX Debugging Tricks and blogs about Debugging DAX using CONCATENATEX
- Ruth Pozuelo Martinez (@CurbalEN) presents DAX Fridays #206: 9 DAX unwritten rules, that will give you away as a beginner!
- Reid Havens (@HavensBI) talks about the Elements of DAX with Brian Grant
- Hima Bindu Marri (@sivahimabindu) explains how to calculate YTD, MTD , QTD in Power BI
📊 Report Authoring and Interactivity
- On the MSSQLTips site, Kenneth A. Omorodion describes how to Dynamically Show or Hide a Visual in Power BI Based on Slicer Selection
- On the Power BI community blog, Pragati Jain describes how to Set Up Default Filters in Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about a Multi-Select Slicer in Power BI
- Reid Havens (@HavensBI) talks about Conditionally Formatting Positive & Negative Line Chart Colors in Power BI
- Dhruvin Shah (@DhruvinShah16) describes how to Draw Average Line in Power BI
- Parv Chana (@parvchana) covers Power Automate Visual and Automatic Page Refresh: Why They Work Well Together
- Patrick Leblanc (@GuyInACube) discusses Report BURSTING with the Power Platform
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Export Power BI to MS Word / PDF Paginated reports with Power Automate and Power BI
- Zoe Douglas describes Using Power Automate to Refresh Data In Power BI
- Olivier Travers (@otravers) explains How to Pimp Your Power BI Reports with Dynamic CSS in the HTML Content Custom Visual and explains How to Hijack Power BI Styles to Apply Your Own
- Matthew Peterson (@mattpetersonbi) talks about Power BI: Use Bookmarks To Make It Easy For End-Users To Reset Filters
- Allison Kennedy provides a Custom Visual Review: Charticulator
- Belinda Allen (@MsBelindaAllen) blogs about Using an Inserted Shape as a Navigation option in Microsoft Power BI
- Spencer Baucke (@JSBaucke) shares a Power BI Power Hour: Build an Amazing Report from Start to Finish
🚀 Deployment, Security and Operations
- On the Power BI blog, David Magar provides a Premium Gen 2 timeline update – Capacity size enforcement and autoscale charges coming up
- Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that the On-premises data gateway April 2021 update is now available
- Christopher Finlan (@cmfinlan) talks about the New way to enable Power BI Premium for your workspaces and apps
- Adam Saxton (@GuyInACube) talks about Source Control with Power BI – Can it be done?
- Wolfgang Strasser (@wstrasser) writes about I thought Power BI Premium per User PPU is only 10$? How to purchase the add-on to Power BI PRO
🌐 General
- On the Power BI blog, Lauren Faber highlights the amazing Power BI customer stories sessions at the Microsoft Business Applications Summit
- Asanka Padmakumara (@asanka_e) explains How to transit users from an existing reporting solution to Power BI
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 189 - Power BI April 2021 Feature Summary
- Gil Raviv (@gilra) shares the ActiveCampaign app v2