Power BI Weekly
Issue #19 - 6th August 2019
Three main updates for you all this week. The Power BI Developer community June & July update has been shared with us, in which we've been told that the use of service principals with the API is now GA, and that Paginated Reports can now be embedded into internal applications (plus plenty more updates). We've also been told about the New Power BI Region in South Africa and the Power BI "Back to School" Contest, whereby entrants submit a Power BI-powered lesson to educate students through the fun and interactive medium of Power BI.
Elsewhere this week, Chandeep Chhabra has taken us through the various DAX Keyboard Shortcuts to help us navigate the function pane more efficiently, and David Eldersveld has written about Data Sonification in Power BI, for those of you wanting/needing to add some audio to your reports.
🛠️ Data Prep
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Get Images from Web Page Into the Power BI Report Using Power Query
- Gerhard Brueckl (@gbrueckl) talks about Data Virtualization in Microsoft Power BI
- On the Excelguru blog, Ken Puls (@kpuls) introduces Power Query Challenge 6 and provides some Solutions
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) blogs about Grouping rows with Power BI / Power Query
🧩 Data Modeling
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Some Simple Ways to Debug Your DAX Measure Code in Power BI: Debugging Virtual Tables
- Chandeep Chhabra (@chandeep2786) talks about DAX Keyboard Shortcuts
- Matt Allington (@ExceleratorBI) describes The FILTER Function in DAX Part 2
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few blogs: Analyze Who Your Lost Customers Are Using Power BI & DAX, How To Allocate Results To Templates At Every Single Row Using Power BI, Showing Actual Results vs Targets Only To Last Sales Date In Power BI and on the Power BI community blog, How To Deal With Multiple Dates In Power BI
- Carl de Souza (@carldesouza) describes Using the GENERATESERIES DAX Function in Power BI
⚙️ Report Design and Visualizations
- David Eldersveld (@dataveld) discusses Data Sonification in Power BI
- Marc Lelijveld (@MarcLelijveld) writes Storytelling with Power BI 2/7: Be dynamic
- Meagan Longoria (@mmarie) tells us to Check Out the Updated Violin Plot Power BI Custom Visual
⚙️ Data Exploration
- Gilbert Quevauvilliers (@GilbertQue) discusses Does the New Look Power BI Service use more or less report page screen real estate?
- Gil Raviv (@gilra) explains how to Find overlapping time periods using PowerQuery – Part 3 Fast & Furious
🚀 Deployment, Security and Operations
- On the Power BI blog, David Magar announces the New Power BI Region in South Africa
- On the Power BI community blog, Jayendran Arumugam writes about Gateway Monitoring & Administrating- Part 1 and Part 2
- Patrick Leblanc (@patrickdba) discusses Siri Shortcuts with Power BI Mobile for iOS
- Roberto Stefanetti (@robstefane) reminds us that from September 1, 2019, content packs are no longer supported on Power BI online
- On the Blue Granite blog, Melissa Coates (@SQLChick) explains Why Power BI Shared Datasets are Critical to a Self-Service BI Implementation
- Carl de Souza (@carldesouza) explains how to Classify Your Data with Power BI Dashboard Data Classification
- On the MSSQLTips site, Dinesh Asanka walks through Monitoring SQL Server Analysis Services with Extended Events
🌐 General
- On the Power BI blog, Sujata Narayana announces Power BI "Back to School" Contest
- Also on the Power BI blog, Alon Baram provides the Power BI Developer community June & July update
- David Eldersveld (@dataveld) shares the Power BI Blogmap at PowerBI.World
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 111 July 2019 Power BI Desktop Update
- Adam Saxton (@guyinacube) presents A new look for Power BI, notifications, Tooltips and more... (July 29, 2019)