Power BI Weekly
Issue #121 - 3rd August 2021
This week, we've been given the Updated Timeline and milestones for Premium Gen2 General Availability, with the team outlining a bunch of updates coming to the metrics app, and sharing that the Gen2 GA is planned for Sept 27th. We've also been told about the new Admin APIs to Determine Access Rights (Public Preview) for various artifact types, and a notice to expect an API later in the summer to query which assets a specific user has access to.
Elsewhere this week, Andy Cutler has written about a new feature in the blog Creating a Power BI Streaming Dataflows Solution, Steve Campbell has joined Reid Havens to describe Implementing Proper Version Control in Power BI, and Allison Kennedy has written a swathe of interesting blogs under the Tokyo Olympics theme, covering Power Automate integration, alerting, small multiples and more. Do check them out!
🛠️ Data Prep
- Andy Cutler (@MrAndyCutler) blogs about Creating a Power BI Streaming Dataflows Solution
- Gerhard Brueckl (@gbrueckl) describes Custom functions and complex return types in Power Query
- On myOnlineTraininghub, Philip Treacy (@OnlineTrainingH) describes a VLOOKUP in Power Query Using List Functions
- On the SQL Server Central blog, Diponkar Paul (@paulswengrr) writes about Why Power Query as an Activity in Azure Data Factory and SSIS?
- Antriksh Sharma (@AntrikshShar) describes How To Load Data from Power BI into SQL Server Power BI and describes How To Load Data In Power BI With Stored Procedure and Parameters
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains how to Know Your Data Better by Column Profiling In Power BI using Power Query and talks about Fuzzy Clustering in Power BI using Power Query - Finding similar values
- Dhruvin Shah (@DhruvinShah16) shares a Power BI Dataflows - Full Course for Beginners
- On the dev.to blog, Sergei Semenkov provides A simple way to import data to Power BI from Mondrian
- Matt Allington (@ExceleratorBI) discusses Improving My COVID Power BI Report and blogs about Correcting Source Data in Power BI
- Melissa de Korte (@_EnterpriseDNA) explains How To Extract Values Before A Specific Text
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Adding working days to a date in DAX calculated column – Unplugged #30, and shares a few tutorials: UNION – DAX Guide, INTERSECT – DAX Guide and EXCEPT – DAX Guide
- Gilbert Quevauvilliers (@GilbertQue) blogs about Modelling – Part 7 Migration from AAS to PPU
- On the Power BI community blog, hp2198 describes How to format all DAX measures at once
- Adam Saxton (@GuyInACube) discusses Measuring RLS Performance in Power BI
- Denis Selimovic (@DenSelimovic) describes how to Change formatting of each individual value dynamically with Calculation Groups
- On the Towards Data Science blog, Wan Chung Huang introduces 2 Tools to Speed up Your Power BI 10x
- Bas Dohmen (@HowToPowerBI) shares My number 1 trick for Time Intelligence
- Antriksh Sharma (@AntrikshShar) describes How To Fix Static Segmentation and Blank Row in DAX Power BI and talks about Months with sales higher than the Average of the year with CALCULATE and ADDCOLUMNS Power BI
- Reid Havens (@HavensBI) describes Creating a Composite Model Against a Power BI Dataset
- Chris Webb (@cwebb_bi) writes about Excel Cube Functions, Dynamic Arrays And Lambdas, Part 1: Getting All The Items From A Set and Part 2: Returning Tables
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 12 - Building Multi Language Reports in Power BI
📊 Report Authoring and Interactivity
- Parker Stevens (@PowerBIElite) describes How to Build a Native Correlation Matrix in Power BI
- Patrick Leblanc (@GuyInACube) presents Smart Narratives and Conditional Formatting in Power BI? Yes please!
- On the Enterprise DNA blog, Mudassir Ali shares a few blogs: Waffle Charts: Power BI Custom Visualization, The Charticulator: Power BI Alternative Visualization Tool, Charticulator: A Visual Creator For Power BI, ,, Create A Bar Chart Visualization With Charticulator and on the Enterprise DNA blog, Comparison Bar Charts With Charticulator In Power BI
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes How to create an In-Page Navigation with Bookmarks and Buttons in Power BI
- Andrzej Leszkiewicz (@avatorl) blogs about Power BI Map: bad or good and shares a good example of a Scatter Chart
- Allison Kennedy has written a bunch of Power BI themed blogs about the Tokyo Olympics
- Dhruvin Shah (@DhruvinShah16) lists the Top 8 Best Practices for Power BI QnA Maker Visual
- On the BlueGranite YouTube channel, Tom Weinandy (@TomWeinandy) shares Anomalies Demo from "AI in a Day" and Forecasting Demo from "AI in a Day"
- Roseanne Levasseur shares a Survey! Exploring visual styles for creators
🚀 Deployment, Security and Operations
- On the Power BI blog, Rick Zu announces the Admin APIs to Determine Access Rights (Public Preview)
- Marc Lelijveld (@MarcLelijveld) explains how to Transform a local into a global Power BI solution – Request access to content
- On the Tessellation Tech blog, Gavin Pedersen describes How to Create a Power BI App
- On the CSG Pro blog, Gavin McLaughlin (@GavinCSGPro) describes How To Start Planning a Power BI Deployment At Your Enterprise
- Reid Havens (@HavensBI) describes Implementing Proper Version Control in Power BI with Steve Campbell
- Also on LaDataWeb, Ignacio Barrau (@ignacho_07) writes Licenciamiento Power Bi [Spanish]
🌐 General
- On the Power BI blog, David Magar shares an Updated Timeline and milestones for Premium Gen2 General Availability
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) discusses Building an End-To-End Analytic solution in Power BI: Part 1—Understanding the Business Problem
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (July 31, 2021)
- Dhruvin Shah (@DhruvinShah16) shares the Power BI PH Community - Monthly Meet Up - July 2021
- Also on the Towards Data Science blog, Salvatore Cagliari covers Measuring Work-Life balance in Power BI