Power BI Weekly

Issue #85 - 17th November 2020

There's been an influx of announcements this week, so brace yourselves... The Power BI November 2020 Feature Summary has been released, including changes to the field and model views, zoom sliders, and.. some amazing Anomaly detection functionality in line charts to add some wow-factor for your report consumers. There's also been some rather nice updates in Power Query & Dataflows including some very welcome functionality in the new Visual Data Prep feature - a new visual interface to help view your Power Query transformation steps.

Additionally, we've been told about the Power BI Premium Gen2 public preview, which includes the Premium per user public preview, which will be rolled out to all tenants by the end of November. Finally, the Power BI Developer community November 2020 update has been released, including the ability to change the orientation of the page navigation in line with the 'new look' of Power BI reports in the service, added support for assigning users to the 'Viewer' role using the API, and many, many more updates.

Aside from updates this week, the article I wanted to point out it one written by my colleague Paul, who's given A designer's perspective on generating custom themes in Power BI, outlining numerous handy tips to help you design a compelling and user-friendly Power BI report. Do check it out!

🛠️ Data Prep

On the Power BI blog, Miguel Llopis (@mllopis) describes What's new in Power Query &Dataflows - November 2020
Also on the Power BI blog, Dharini Sundaram (@heydharini) announces Visual Data Prep public preview Diagram View in Power Query
Imke Feldmann (@TheBIccountant) explains how to Improve File Import from SharePoint in Power BI and Power Query
Erik Svensen (@donsvensen) explains How to connect to CDS from Power BI – Or where the h.. can I find the server URL
On the Enterprise DNA blog, Melissa de Korte explains how to Convert The Date Table Function Into A Table Query In Power BI
On the Towards Data Science blog, Peter Hui discusses Power BI Functions—List.Contains, List.ContainsAny, List.ContainsAll
Dhruvin Shah (@DhruvinShah16) talks about the Automatic Table Detection from Excel File in Power BI

🧩 Data Modeling

The Azure updates team writes that SQL Server Analysis Services Virtual Machine images now available
Gerhard Brueckl (@gbrueckl) blogs about Power BI & Big Data – Using pre-calculated Aggregations of Semi- and Non-Additive Measures
Matt Allington (@ExceleratorBI) describes how to Extract Tabular Data From Power BI Service to Excel
Marc Lelijveld (@MarcLelijveld) wonders Will query folding apply to Power BI Composite models?
On the SQLBI blog, Marco Russo (@marcorus) discusses the Formula engine and storage engine in DAX
Gilbert Quevauvilliers (@GilbertQue) explains How to use Vertipaq Analyzer with DAX Studio for Power BI Model analysis
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about DAX Calculation: Context & The Calculation Engine and describes Finding The Percent Of Total In Power BI
Jarret Moore explains how to Get Updated Last Refresh Date And Time In Power BI
On the Data Bear blog, Mariska Oosthuizen describes How to view and retrieve all measures
On the Power BI blog, Kelly Kaye (@MS_KellyKaye) writes Join us! Power BI Training – Advanced Data Modeling
On the Burningsuit blog, Alison Box explains How DAX Treats Nulls & Zeros
Ruth Pozuelo Martinez (@CurbalEN) talks about 3.5 ways to open Power BI datasets/reports from within Excel
Reid Havens (@HavensBI) describes Formatting All DAX Measures at Once with Tabular Editor
Avi Singh (@powerbipro) talks about a Power BI Fiscal Calendar: Can You Handle Season to Date?

📊 Report Authoring and Interactivity

On the Power BI blog, Ancy Philip (@ancyphilip) writes about Anomaly detection (preview)
On the Business Intelligist blog, Business Intelligist (@bizintelligist) explains that Power BI Anomaly Detection is a Home Run
On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) writes about Anomaly Detection in Power BI
On the endjin blog, Paul Waller (@Crashbangwaller) talks about Generating custom themes in Power BI – A designer's perspective
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes how to Sort Visualizations Dynamically In Your Power BI Reports
On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) compares Excel Dashboards vs Power BI Dashboards
Patrick Leblanc (@GuyInACube) walks through Using IMAGES in Power BI
On the Towards Data Science blog, Nikola Ilic (@DataMozart) walks through Slicing data with Images in Power BI
Dhruvin Shah (@DhruvinShah16) describes how to Display selected value from slicer to Power BI Report
On Le CFO Masqué, Kim Leblanc writes Comment créer un bouton pour extraire une page de rapport [French]

🚀 Deployment, Security and Operations

On the Power BI blog, David Magar announces the Preview Availability of Improved Analytics with Next-Generation Power BI Premium
Adam Saxton and Patrick Leblanc (@GuyInACube) describe how to Run faster and see performance benefits with Power BI Premium Gen 2
Also on the Power BI blog, Christopher Finlan (@cmfinlan) writes that Power BI Premium per user public preview now available
Also on the Power BI blog, Amit Shuster (@ShusterAmit) shares the Power BI Developer community November 2020 update
Adam Saxton (@GuyInACube) provides a Power BI Service Principals 101
Martin Schoombee (@MartinSchoombee) describes Automating Power BI deployments: Assign workspace permissions
Wolfgang Strasser (@wstrasser) writes Let Me Automate You – Take Power BI Automation To The Next Level
Parker Stevens (@PowerBIElite) talks about Building a Power BI Admin View Part 4: Visualizing the Data
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) writes about Dynamic Row Level Security in Power BI with Exclude and Include Rules
Chris Webb (@cwebb_bi) blogs about Visualising Azure Analysis Services Processing Tasks With The Job Graph Events Sample
On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) describes how to Process Analysis Service with Firewall in ADF only
Matthew Peterson (@mattpetersonbi) writes Power BI Makes APPs, too? A Quick Guide to Understanding that an APP is like a CONTAINER
Laura Graham-Brown (@Laura_GB) writes about Scheduled Refresh for your Dataflow
The Power BI team (@MSPowerBI) talks about the Data lineage and impact analysis enhancements

🌐 General

On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) covers the Power BI November 2020 Feature Summary
Ruth Pozuelo Martinez (@CurbalEN) summarizes the Power BI Desktop Update November 2020 in 9 minutes
The Power BI team (@MSPowerBI) talks about Endorsement of Power BI reports and apps
Gil Raviv (@gilra) shares the recording: Bad Practices in Power BI
Adam Saxton (@GuyInACube) shares the Power BI updates, DAX Puzzles and more… (Roundup | Nov 9, 2020)
Adam Saxton and Patrick Leblanc (@GuyInACube) share the 🔴 Power BI tips from the Pros – LIVE (Nov 14, 2020) (Member Chat 2nd Half)
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 168 - Premium per User is here (in preview!)
Also on the Power BI blog, Kelly Kaye (@MS_KellyKaye) writes Join us! Power BI Dev Camp Thursday 19 November, 2020
On LaDataWeb, Ignacio Barrau (@ignacho_07) writes about Power Bi Service dentro de Teams [Spanish]