Power BI Weekly
Issue #16 - 16th July 2019
I'd like to extend a warm welcome to those who have signed up after seeing me introduce Power BI Weekly at the London Power BI User Group last week, and, of course, a very warm welcome to the rest of this week's new subscribers. This week, we've been provided the On-premises data gateway July 2019 update and we've been given the ability to Send dataset refresh notifications to others - a very handy feature for notifying relevant parties of refresh failures. Another Power BI-related announcement is that query interleaving for Azure Analysis Services is now in development. Also in this week's edition, Lars Schreiber has written an interesting article describing How to identify Measures not used in your pbix file, utilizing some SSAS DMVs and the new performance analyzer feature.
🛠️ Data Prep
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) writes about Referencing the Next Row in Power Query
- Kasper de Jonge (@kjonge) describes How to enable scheduled refresh for your custom connector
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) provides a Deep dive into DAX evaluation context and walks through Understanding the Application of Calculation Items
- Matt Allington (@ExceleratorBI) writes about Pareto Analysis in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) posts a number of instructional videos: Create Dynamic Cumulative Totals Using DAX In Power BI, Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX, How To Create Virtual Relationships Using TREATAS In Power BI, How You Can Re-Use Moving Averages In Power BI, How You Can Predict Profitability In The Future Using Power BI and Show Days Before Or After A Selected Date Using Power BI
- Gilbert Quevauvilliers (@GilbertQue) describes How to get a line break in a DAX measure for Labels or Titles in a Power BI report
- On the PowerPivotPro blog, Rob Collie (@robcolli3) writes about SUMX – The 5-point palm, exploding fxn technique
- On the DataAP blog, Hariharan Rajendran implements Top N for each Previous & Current Year
- Devin Knight (@knight_devin) and Erin Ostrowsky (@RadiantData) present Power BI Interview Questions – Volume 03 – DAX
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) writes about The Dynamic Time Matrix
- On the Visual BI blog, Manikandan Muruganantham writes about Exporting Measure and Column formulas from Power BI
- The Azure updates team highlights In development: query interleaving for Azure Analysis Services
⚙️ Report Design and Visualizations
- Chris Webb (@cwebb_bi) writes about Why Power BI Slicers Sometimes Show Values That Do Not Exist
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses Using Great Color Schemes In Your Power BI Data Visualization
- Christopher Finlan (@cmfinlan) describes how to Use a Conditional Preview Image in Paginated Reports subscriptions in Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that the On-premises data gateway July 2019 update is now available
- Also on the Power BI blog, Kay Unkroth writes about Sending refresh notifications to others
- Brett Powell (@BrettPowell76) explains how to Analyze SQL Agent Job History with Power BI
- On the DB Best blog, DeNisha Malone (@thepowerbiqueen) talks about Reaching the limit with Power BI Premium resources
- Lars Schreiber (@SchreiberLars) describes How to identify Measures not used in your pbix file
🌐 General
- Paul Turley (@paul_turley) discusses Power Platform Virtual Conference
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) writes about First ever Power BI event in LatAm – we are the sponsors
- On the C5insight blog, Doug Allen writes about What is Power BI An Introduction