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
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- 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
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- 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
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.