Power BI Weekly

Issue #41 - 14th January 2020

Radio-silence from the Power BI team this week, so let's dive straight into the highlighted blogs. Miguel Escobar has compared DAX and Power Query solutions in their blog Static Segmentation in Power BI / DAX / Power Query, Ben Gribaudo has written about Control Structure in their Power Query M Primer series, and Teo Lachev has shared some interesting findings about the Power BI Pro Storage Quota.

This week I also want to mention a new community site created by Ignacio Barrau, which is intended to be a place where anyone can share their Power Platform / Azure Data Platform content (for free). The site's content is currently in Spanish, but with the power of auto-translation within browsers nowadays, this shouldn't stop you from consuming the content! This site is called LaDataWeb, and you'll find a blog from this site further down the newsletter. You'll see blogs written in a non-English language tagged with [<language>].

🛠️ Data Prep

On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Get the Image URL in Power BI Using Power Query Get Table from Example, covers Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed and describes how to Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows
Ben Gribaudo (@bgribaudo) writes Power Query M Primer (Part 14): Control Structure
Matt Allington (@ExceleratorBI) discusses Extracting Data from Complex Web Pages with Power BI
Parv Chana (@parvchana) writes about Self-serve data prep at lightening fast speed with Power BI dataflows and Azure Data Lake
On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) talks about DAX vs Power Query: Static Segmentation in Power BI / DAX / Power Query

🧩 Data Modeling

On the RADACAD blog, Reza Rad (@Rad_Reza) highlights the New Video Course: DAX and Calculations in Power BI
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) posts a few blogs: Advanced DAX For Power BI: Implementing Ranking Logic Across Unique Insights, A Power BI Training On Budgeting Scenarios Using DAX, Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis, Scenario Analysis Techniques Using Multiple 'What If' Parameters and Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX
Patrick Leblanc (@GuyInACube) presents Want to use a URL for your text column in Power BI Desktop? Check THIS out! and provides 3 REASONS to use a single dataset for your Power BI reports

⚙️ Report Design and Visualizations

On the SQLBI blog, Marco Russo (@marcorus) writes about Why reports obtained with Analyze in Excel can be slower
On the Visual BI blog, Bhupinder Singh blogs about Gannt Chart Configuration for Power BI – A Step by Step Guide and walks through Alerting Techniques in Gannt Chart for Microsoft Power BI
Also on the Visual BI blog, Vipin Suresh covers Data Label Customization Funnel/Pyramid Chart for Microsoft Power BI
On the Blue Granite blog, Jason Cantrell provides a Deep Dive into Linear Regression in Power BI: Key Influencers
On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Diseñando fondos de reportes [Spanish]

⚙️ Data Exploration

On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares some Power BI Mobile Reporting Tips and Techniques

🚀 Deployment, Security and Operations

Brett Powell (@BrettPowell76) explains how to Retrieve Power BI Pro Licensed Users
On the Prologika blog, Teo Lachev (@tlachev) writes about the Power BI Pro Storage Quota
Gil Raviv (@gilra) writes about Power BI Pixel – A new way to track usage on Power BI
Paul Turley (@paul_turley) blogs about Getting Started with the New Power BI Activity Log API

🌐 General

Matthew Roche (@SQLAllFather) blogs about Building a data culture
On the RADACAD blog, Reza Rad (@Rad_Reza) shares a Microsoft Regional Directors Power BI Report and writes about What Happens to Your Job With the Revolution of Power BI and Self-Service BI
On the Prima blog, David Johnston highlights 5 Resources to Help a Power BI Developer