Power BI Weekly
Issue #61 - 2nd June 2020
This week, we've been told about the new Direct Query support for Power BI Dataflows - as long as you're using the enhanced compute engine in your Premium capacity, you're good to go. We've also been told that the Page view for Paginated Reports is now available in Power BI, and the Power BI Report Server May 2020 Feature Summary has been shared. Finally, we've been given a roadmap update on what's next for the new workspace experience upgrade in the coming months, including admins acquiring the ability to block the creation of classic workspaces.
Elsewhere this week, Gilbert Quevauvilliers has described how you can selectively show report pages for specific users using a combination of RLS and conditional formatting, Eka Ponkratova has spoken about The secret recipe for modern Oracles describing how to perform time-series forecasting with Python, and Melissa Coates has highlighted the Updated Whitepaper: Planning a Power BI Enterprise Deployment.
🛠️ Data Prep
- On the Power BI blog, Mohammad Ali (@mohaali45) announces Power BI Dataflows Direct Query Support
- Chris Webb (@cwebb_bi) blogs about Optimising The Performance Of Power Query Merges In Power BI, Part 1
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) describes some Power BI Desktop Data Source Considerations
- On the SQLBI blog, Marco Russo (@marcorus) discusses Optimizing access to Azure Data Lake Storage (ADLS) Gen 2 in Power Query
- Spencer Baucke (@JSBaucke) describes Web Scraping in Power BI Pt II
- Ulrik B. Carlsson (@crmchartguy) talks about DirectQuery CDS from Power BI
- On Le CFO Masqué, Kim Leblanc writes Power BI – Vous rencontrez des problèmes avec l’addition des heures? [French]
- Eka Ponkratova describes The secret recipe for modern Oracles
- Purna (Chandoo) Duggirala (@r1c1) describes How to export YouTube video comments to Excel file – Free template + Power Query case study
- Jon Acampora (@excelcampus) shares a VBA Macro to Create Power Query Connections for All Excel Tables
🧩 Data Modeling
- Chandeep Chhabra (@chandeep2786) writes about Understanding Earlier Function in DAX
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Handling customers with the same name in Power BI
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes SUM vs SUMX [Spanish]
- On myOnlineTraininghub, Philip Treacy (@OnlineTrainingH) describes how to Show Report Filter Pages for Power Pivot PivotTables
⚙️ Report Design and Visualizations
- On the Access Analytic blog, Wyn Hopkins (@wynhopkins) explains how to Create Power BI Themes
- Patrick Leblanc (@GuyInACube) wonders Can we have ANIMATED Power BI visuals?
- On the Purple Frog Systems blog, Jon Fletcher walks through Sorting a Power BI table by multiple columns
- On the Power BI Tips and Tricks blog, Alice Drummond (@AliceDiscoverEI) explains how to Create Custom Mapbox Styles
- Laura Graham-Brown (@Laura_GB) talks about Power Apps – Embed a Power BI Chart
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about 5 tips to boost your Power BI development
⚙️ Data Exploration
- On the Power BI community blog, James Raddock writes about Power BI Export Limitations - Parts 1 & 2
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) explains how to Enhance Power BI report with Tooltip Pages
🚀 Deployment, Security and Operations
- Matthew Roche (@SQLAllFather) writes about One report for multiple audiences
- Gilbert Quevauvilliers (@GilbertQue) writes Did you know you can now selectively show report pages for specific users in Power BI?
- On the Power BI community blog, Jayendran Arumugam (@Jayendran_A) talks about Data Gateway : Automation using PowerShell - Part 1
- Nicky van Vroenhoven (@NickyvV) blogs about Power BI Governance & Administration - Organizational Visuals
- Brett Powell (@BrettPowell76) shares some Simple DirectQuery Performance Tips
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) describes how to Hot Swap Power BI Report Connections
- Melissa Coates (@SQLChick) highlights the Updated Whitepaper: Planning a Power BI Enterprise Deployment
🌐 General
- On the Power BI blog, Christopher Finlan (@cmfinlan) writes that Page view for Paginated Reports now available in Power BI
- Also on the Power BI blog, Lukasz Pawlowski (@lukasztweets) shares a Roadmap update: What's next for the new workspace experience upgrade in the coming months
- Also on the Power BI blog, Rien Hu shares the Power BI Report Server May 2020 Feature Summary
- Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY Power BI tips from the Pros – LIVE Hangout (May 30, 2020)
- Devin Knight (@knight_devin) shares the Power BI Monthly Digest – May 2020 with Matt Peterson
- Brett Powell (@BrettPowell76) provides a Power BI pro guide to Azure synapse analytics
- Mariano Gomez describes some Fun and Non-Traditional uses for Power BI, Power Apps and Power Automate
- The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 121
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 147 - Interview with Will Thompson
- On the MSSQLTips site, Scott Murray writes about Power BI: What I wish I knew when I started?