Power BI Weekly
Issue #30 - 22nd October 2019
Last Monday, we were given the Power BI Desktop October 2019 Feature Summary, filled with numerous exciting updates. My personal favourite is the new "PBIDS" file format, which is a new Desktop file allowing you to initialize data source connections before a user opens a file. Great for prepping beginner Power BI users with the correct data source connection. Last Monday, we were also told about On-premises data gateway management via PowerShell (Public Preview) and, later on in the week, we were told about the new feature allowing us to Refresh our Power BI datasets using Microsoft Flow.
Elsewhere, Justyna Lucznik has joined the GuyInACube channel for the week, describing how to Ask a question with the new Q&A visual in Power BI Desktop, Marco Russo has spoken about Showing the top 5 products and Others row, and Augustin de la Fouchardiere has described how to generate complex organization charts in Power BI (the answer is Visio!)
🛠️ Data Prep
- Darren Gosbell (@darrengosbell) describes Extending the Analysis Services Command Timeout in Power BI
- Chris Webb (@cwebb_bi) provides an Introduction To M In Power Query And Power BI
- Carl de Souza (@carldesouza) describes How to Change a Data Source in a Power BI Report
- Adam Saxton (@GuyInACube) blogs about Power BI case sensitivity, Power Query stored procedure and more... (October 14, 2019) and describes Looking at the Lineage View in Power BI October 2019
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) writes Power Query – Get Started!
- Lars Schreiber (@SchreiberLars) writes about Table.Profile and its unknown second parameter
- Matthew Roche (@SQLAllFather) writes Power BIte: Dataflows vs. datasets, alludes to some Power BI dataflows best practices and describes Dataflows, CDM folders and the Common Data Model
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) blogs about Handling Different Time Zones in Power BI / Power Query
- Angela Henry (@SQLSwimmer) writes about the Updated Data Profiling in Power BI Desktop
🧩 Data Modeling
- On the RADACAD blog, Reza Rad (@Rad_Reza) talks about Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX
- Adam Saxton (@GuyInACube) writes about Power BI: Case of the unexplained date LastDate in DAX
- Phil Seamark (@PhilSeamark) walks through Pivoting Data for Speed, writes Creative Aggs Part I : Introduction and Creative Aggs Part II – Horizontal Aggs
- On the SQLBI blog, Marco Russo (@marcorus) walks through Showing the top 5 products and Others row
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains How To Quickly Create Virtual Groups In Power BI, describes how to Use DAX To Segment & Group Data In Power BI, explains how to Create A New Table In Power BI: How To Implement Budgets & Forecasts Automatically Using DAX, discusses Using The ALL Function In Power BI For High Quality Insights and writes about Time Intelligence In Power BI: How to Calculate The Number of Transactions Made in the Last N Days
⚙️ Report Design and Visualizations
- Carl de Souza (@carldesouza) explains How to Display an Image from a Url in a Power BI Report and covers Using Tooltips to Show an Image on Hovering Over a Power BI Record
- On the Power BI community blog, Augustin de la Fouchardiere explains How do you generate complex organization charts in Power BI? The answer is Visio.
- Gil Raviv (@gilra) writes about Bad Practices in Power BI: A New Series & the Pie Chart Prologue
- Chandeep Chhabra (@chandeep2786) describes how to Show Values in Rows in a Pivot Table
⚙️ Data Exploration
- Justyna Lucznik (@JustynaLucznik) explains how to Ask a question with the new Q&A visual in Power BI Desktop
- On the Visual BI blog, Sathya Narayana Karthikeshwar (@karthikeshwar) describes how to Q&A your Data in Power BI
- Eugene Meidinger (@sqlgene) asks Where do people get stuck with Power BI?
🚀 Deployment, Security and Operations
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes about On-premises data gateway management via PowerShell (Public Preview)
- Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) explains how to Refresh your Power BI dataset using Microsoft Flow
- On the Power BI community blog, Michal Dvorak (@nolockcz) explains How to Protect a Dataset from Deletion
- Craig Porteous (@CPorteous) describes How to refresh Power BI Dataflows with PowerShell
- John White (@diverdown1964) explains how to Keep your Power BI SharePoint reports current with Microsoft Flow
- Also on the Power BI community blog, SyndicateAdmin writes From Forms to PowerBI and the glue is Microsoft Flow
🌐 General
- On the Power BI blog, Amanda Cofsky (@MissAmandaN) posts the Power BI Desktop October 2019 Feature Summary
- Also on the Power BI blog, Kelly Kaye explains how to Win Power BI Swag with Community Kudopalooza
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 121 - October 2019 Power BI Desktop Update & News
- Devin Knight (@knight_devin) discusses Power BI Monthly Digest with Manuel Quintana – October 2019