Power BI Weekly

Issue #5 - 29th April 2019

This week, amongst lots of other great content, Marco Russo has written an illuminating answer to a question on Quora about the Hate and love for the DAX language, Dustin Ryan helps us Visualize NFL Draft History with Power BI, and Gilbert Quevauvilliers has shared Power BI Premium Performance - Part 2 | Optimization of your Power BI Model.

Elsewhere, there's been an influx of announcements and updates from the Power BI team. Here they are:

🛠️ Data Prep

On the Power BI blog, Christopher Finlan (@cmfinlan) writes that Power BI Dataset data source support for Paginated Reports is now available
On the RADACAD blog, Leila Etaati (@leila_etaati) describes how to Export data from Power Query to Local Machine or SQL Server using R scripts
On the Power BI community blog, Amit_PowerBIPro talks about Data Profiling in Power BI (Power BI Update April 2019)
On the MSSQLTips site, Eduardo Pivaral (@EduardoDBA) describes Getting Started with Power BI and Power Query for Simple ETL - Part 2
Wolfgang Strasser (@wstrasser) posts Slides for my "Introducing Power BI dataflows" session at Intelligent Cloud Conf in Copenhagen
Imke Feldmann (@TheBIccountant) explains How to cancel your Power Query refreshes fast in Power BI and Excel
On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) explains how to Combine or Append Data: Combining Excel Files
On the Blue Granite blog, Gary Lock (@garylock) talks about Power BI Streaming Datasets for More Than IoT

🧩 Data Modeling

On the RADACAD blog, Reza Rad (@Rad_Reza) writes Back to Basics: Power BI Relationship Demystified and writes Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified
On the SQLBI blog, Marco Russo (@marcorus) writes about Hate and love for the DAX language
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains how to Find Out How To Quickly Create Virtual Groups In Power BI

⚙️ Report Design and Visualizations

On the Official PASS blog, Angela Henry talks about Adding PowerApps to Power BI
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses Using Dynamic Visuals On Ranking Based Parameters In Power BI
Matt Allington (@ExceleratorBI) describes how to Show or Hide a Power BI Visual Based on Selection
On the MSSQLTips site, Gauri Mahajan covers Getting Started with the Key Influencers Visual in Power BI Desktop
Patrick Leblanc (@patrickdba) explains how to Make your Power BI report POP with a custom background
Dustin Ryan (@SQLDusty) talks about Visualizing NFL Draft History with Power BI
On the DB Best blog, DeNisha Malone (@thepowerbiqueen) talks about Power BI — Table for Key Measures — Episode 4

⚙️ Data Exploration

Adam Saxton (@guyinacube) takes Buttons in Power BI Desktop to the Next Level with Amanda Cofsky
Patrick Leblanc (@patrickdba) explains how to Improve Power BI Report performance by using the filter pane

🚀 Deployment, Security and Operations

On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) explains how to Refresh Power BI Dataset from Azure Data Factory - Part 1
On the Power BI blog, Arthi Ramasubramanian Iyer writes about On-premises data gateway April 2019 update is now available, highlights the Enhancements to On-premises data gateway management in the Power platform Admin center and explains how to Skip Test Connection for On-premises and Cloud Data Sources
Chris Webb (@cwebb_bi) discusses Using The "Skip Test Connection" Option For Power BI Data Sources To Avoid Scheduled Refresh Failures
Also on the Power BI blog, Kay Unkroth walks through Exporting the workspaces list from the Admin Portal and blogs about Duplicating workspaces by using Power BI cmdlets
Also on the Power BI blog, Swati Gupta highlights the New Power BI Premium summary and workload metrics available in the admin portal
Brett Powell (@BrettPowell76) writes about Premium capacity contents
Also on the Power BI blog, Bhavik Merchant (@BhavikMerchant) announces Query Caching in Power BI Premium
Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) announces the Power BI Home General Availability (GA) & Roadmap
On the Azure blog, Christian Wade (@_christianWade) writes about the Governance setting for cache refreshes from Azure Analysis Services
Gilbert Quevauvilliers (@GilbertQue) writes about Power BI Premium Performance – Part 2 | Optimization of your Power BI Model
Christopher Finlan (@cmfinlan) describes how to Use Microsoft Flow to archive PDFs of your Paginated Reports in Power BI
Soheil Bakhshi (@biinsightnz) provides some Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One Shot with DAX Studio
On the Kloud blog, Darren Robinson (@darrenjrobinson) blogs about Outputting data from an Azure Function to Power BI with PowerShell

🌐 General

On the Power BI blog, Miguel Martinez (@maikelson) writes Live now, full session catalog for Microsoft Business Applications Summit 2019
Dustin Ryan (@SQLDusty) highlights the Power BI Governance 101 at SQL Saturday 820 in Jacksonville, Florida on May 4
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 97 - Interview with Matthew Roche
Adam Saxton (@guyinacube) covers Power BI Paginated, DAX, Power Query and more... (April 22, 2019)
On the Perficient blog, Sanjana Jayachandran writes about Analytics: Why Power BI makes a better choice than Excel
Gil Raviv (@gilra) provides a report about Game of Thrones on Facebook with Power BI