Power BI Weekly

Issue #67 - 14th July 2020

The Power BI 2020 release wave 2 notes have surfaced in the last week. Lots of exciting features are in the pipeline, including a Small Multiples visual, Power BI Dataflows & ADLS g2 integration at the workspace level, and DirectQuery over Power BI and Azure Analysis Services (which is the new "Enterprise semantic modeling" feature that Christian Wade demoed at MBAS a couple of months ago). But there are many more than that - please do check it out.

Other than the release plan, this week we've been told about the New contact list for Power BI apps and the option to allow contributors to update apps, and that the .NET Core support for Azure Analysis Services client libraries is in preview. Elsewhere, Mimoune Djouallah has described Rendering 1.2 Million points in PowerBI using Icon Map, and Natalie Garces has explained How to Create a Control Chart in Power BI.

🛠️ Data Prep

On the DataAP blog, Hariharan Rajendran (@imhariharanr) writes about On-Prem SharePoint Folder as a Source in Power BI - Part 1 and Part 2 SharePoint.Contents
On the Excelguru blog, Ken Puls (@kpuls) delves into Creating Power Query Based Calendars
Vivek Ranjan (@imvivran) blogs about Combining multiple files in a Folder: Power Query
On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Import data from PDF file into Microsoft Excel using POWER QUERY Convert PDF to Excel
Ruth Pozuelo Martinez (@ruthpozuelo) explains how to Write if statements like a Pro in Power Query and describes how to Conditionally replace values in Power Query in one step

🧩 Data Modeling

Chris Webb (@cwebb_bi) writes Migration From Analysis Services Multidimensional – Your Feedback Needed!
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) introduces LOOKUPVALUE
On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes TIQ Part 1—How to destroy your Power BI model with Auto Date/Time
On the endjin blog, Carmel Eve (@carmel_eve) writes a Quick tip – Removing totals from a matrix in Power BI
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: Using ALLEXCEPT To Stop The Cumulative Total From Resetting, Calculate Days Of Zero Stock – Power BI Inventory Management Insights, Segmenting Dimensions Based On Ranking – Advanced Analytical Technique For Power BI, Budgeting Performance Segmentation Using DAX In Power BI, Optimizing Your Power BI Formula Using Advanced DAX Functions, Advanced Tips To Optimize Your Power BI Table, Cluster Analysis Visualization Techniques In Power BI and Sam McKay Cfa Grouping Results Based On Performance Vs Benchmarks In Power BI
On the Data Bear blog, Mariska Oosthuizen writes about Calculated Columns and Measures
Dhruvin Shah (@DhruvinShah16) describes How to Use Variable in DAX Formula with Power BI Measures and Calculated Columns
Chandeep Chhabra (@chandeep2786) explains how to Calculate Percentile in Power BI

📊 Report Authoring and Interactivity

Mimoune Djouallah (@mim_djo) talks about Rendering 1.2 Million points in PowerBI using Icon Map
Laura Graham-Brown (@Laura_GB) describes how to Personalize Visuals
On the Towards Data Science blog, Natalie Garces describes How to Create a Control Chart in Power BI
Also on the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Dynamic filtering in Power BI
On the Prologika blog, Teo Lachev (@tlachev) writes about Designing Responsive Power BI Reports (Part 2)
Ruth Pozuelo Martinez (@ruthpozuelo) presents DAX Fridays #179: Use a slicer to highlight values instead of filter them in Power BI
Vivek Ranjan (@imvivran) shares a few blogs: Power BI Bookmarks, Presenting with Bookmarks: Power BI, Switching Visuals using Bookmarks: Power BI Desktop and Power BI Visual: Q&A
Reid Havens (@HavensBI) writes about the Dual Axis Line Chart in Power BI
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report
Parker Stevens (@PowerBIElite) describes how to Power BI Report Design for Maximum Accessibility
On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Armá tu tema o plantilla de formatos [Spanish]
On Qiita, Yugo Shimizu (@yugoes1021) writes [Power BI Tips] Power BI で信号機が作りたい [Japanese]

🚀 Deployment, Security and Operations

The Azure updates team writes that the .NET Core support for Azure Analysis Services client libraries is in preview
Marc Lelijveld (@MarcLelijveld) writes about Why you should care about Power BI Deployment Pipelines
Meagan Longoria (@mmarie) describes Refreshing a Power BI Dataset in Azure Data Factory
Adam Saxton (@GuyInACube) posts OMG a CPU Spike on my Power BI Premium capacity! What now???
Patrick Leblanc (@GuyInACube) talks about Incremental Refresh with Integers in Power BI
On the Power GI blog, Cyrus Christian highlights that Usage Metrics now available in Power BI Government
On the SQL Shack blog, Aveek Das (@avikoleum) explains how to Add users to a Power BI workspace using PowerShell
Ruth Pozuelo Martinez (@ruthpozuelo) describes how to Schedule data downloads / exports in Power BI
Dhruvin Shah (@DhruvinShah16) explains how to Create a Contact List for your Power BI Apps and explains how to Allow Contributor Role Users to Update Power BI App Content
On the MSSQLTips site, Kenneth A. Omorodion covers Power BI Incremental Refresh for SQL Sources
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) says that Power BI Is Too Much for One Person: Roles in the Power BI Development
Phil Seamark (@PhilSeamark) covers Using Visual Studio Code with Power BI
Kasper de Jonge (@kjonge) describes Processing partitions \ tables in parallel

🌐 General

On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the New contact list for Power BI apps and the option to allow contributors to update apps
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 152 - 2020 Release Wave 2 Plan for the Power BI Desktop review
On the dev.to blog, Amit Shuster (@ShusterAmit) discusses Power BI for Developers - Embed Analytics in Your Application [Virtual Event]
Adam Saxton (@GuyInACube) talks about the Power BI community posts... (Roundup | July 6, 2020)
Paul Turley (@paul_turley) discusses Doing Power BI the Right Way
On the Blue Granite blog, Evan O'Neill describes Monitoring Azure Data Factory v2 Using Power BI
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about how to Drive a data culture in your organization! by Marc Lelijveld