Power BI Weekly Issue 31: 29th October 2019
The now GA Automated Machine learning in Power BI looks awesome - not had a chance to play with it myself. But the way Power BI/Microsoft seems to be democratizing AI at the moment is pretty incredible. There have been a few other numerous updates and announcements in the last week:
- Announcing the new contact lists for reports and dashboards in the Power BI service
- Power BI Service and Mobile September 2019 feature summary
- On-premises data gateway October 2019 update is now available
This week Matthew Roche has written a thought-provoking article about the successful implementation of BI within a business, writing that It all comes down to culture. Have a read! Elsewhere, Prathy Kamasani describes how to get a Power BI Card visual to show flags/warnings , and Marc Lelijveld has described how to Move dataflows across workspaces with the Power BI REST API.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the Power BI blog, Ancy Philip (@ancyphilip) announces the Automated Machine learning in Power BI general availability
- On the RADACAD blog, Leila Etaati (@leila_etaati) provides an Overview of Available AI and ML capabilities in Power BI
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Extract Values Present in Two Lists
- On the Power BI Tips and Tricks blog, Steve Campbell provides a Historical Stock Price Function in Power Query
- Chandeep Chhabra (@chandeep2786) explains how to Calculate Custom Fiscal Year and Quarter in Power Query
- Imke Feldmann (@TheBIccountant) provides a Performance tip for aggregations after joins in Power Query and Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses Power BI Query Parameters: Optimizing Tables
- Matthew Roche (@SQLAllFather) shares a Power BIte: Sharing and reuse with dataflows and datasets and describes Using and reusing Power BI dataflows
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) provides a tool to Make PBIDS Files
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- Chris Webb (@cwebb_bi) writes about Excel PivotTable Query Performance With Analysis Services, Power Pivot And Power BI (Revisited)
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: Calculating Average in Power BI: Isolating Weekday or Weekend Results Using DAX, Calculating Average in Power BI: Isolating Weekday or Weekend Results Using DAX, Power BI Exchange Rates: An Update To Multiple Currencies Management, Power BI Data Sets: Learn How To Detect Abnormal Behavior Using DAX and Running Totals in Power BI: How Calculate Using DAX Formula
- On the SQLBI blog, Marco Russo (@marcorus) analyzes the performance of DISTINCTCOUNT in DAX
- Gilbert Quevauvilliers (@GilbertQue) describes How to see what the actual values are in a FILTER when using a DAX Measure
- Phil Seamark (@PhilSeamark) writes Creative Aggs Part II : Horizontal Aggs and Part III : Accordion Aggs
- On the Power BI community blog, Amit Chandak (@amitchandak78) blogs about Comparing Data Across Date Ranges
- Kasper de Jonge (@kjonge) describes how to Figure out which columns and measures are used in your SSAS Tabular model
- Ken Puls (@kpuls) asks How do You Design Your Data Model?
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- Patrick Leblanc (@GuyInACube) highlights One little change to improve Power BI slicer performance (BANANAS!!!)
- On the Visual BI blog, Vipin Suresh writes about the Advanced Gauge: Custom Visuals for Microsoft Power BI
- Prathy Kamasani (@pkamasani) describes how to get the Power BI Card visual to show flags/warnings
- On the PowerPivotPro blog, Rob Collie (@robcolli3) writes about the Head to Head Comparison Infographic in Power BI
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the new contact lists for reports and dashboards in the Power BI service
- Patrick Leblanc (@GuyInACube) explains how to Remove CONFUSION in your Power BI report with this little feature
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) writes that the On-premises data gateway October 2019 update is now available
- Marc Lelijveld (@MarcLelijveld) describes how to Move dataflows across workspaces with the Power BI REST API
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) talks about Power BI Workbooks
- Adam Saxton (@GuyInACube) describes how to Use Microsoft Flow, and other options, to refresh your Power BI dataset
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) provides the Power BI Service and Mobile September 2019 feature summary
- Adam Saxton (@GuyInACube) talks about the Worst pie chart ever in Power BI & swords (Roundup | October 21, 2019)
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Learning About Power BI at Microsoft Ignite 2019 North America: Reza's Sessions
- On the Power BI community blog, The Power BI team (@MSPowerBI) highlights some Power BI Training Content
- Matthew Roche (@SQLAllFather) writes that It all comes down to culture
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.