Power BI Weekly Issue 20: 13th August 2019
In the past week, we've been given the Power BI Service and Mobile July 2019 feature summary and the Paginated Reports August 2019 Feature Update. We've also been told that Connecting Azure Analysis Services to Azure Data Lake Storage Gen2 is now possible - see a walkthrough of that integration here.
Also in the past week: Phil Seamark has written about DAX Fusion, a little known query optimizer making our DAX code run as quickly as possible behind the scenes, and Christian Wade has provided a 2019 release wave 2 overview video, talking about data protection, lineage views, and more.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the Power BI blog, Daniel Rubiolo (@DanielDrubiolo) talks about Connecting Azure Analysis Services to Azure Data Lake Storage Gen2 and on the Power BI community blog, provides a walkthrough
- Chris Webb (@cwebb_bi) covers Power Query/M Optimisation: Getting The Maximum Value From A Column, Part 1 and Part 2
- Also on the Power BI community blog, Ignacio Barrau (@ignacho_07) describes how to Call custom functions file from Github or local file
- Daniil Maslyuk (@DMaslyuk) writes about Safely removing columns in Power Query
- Lars Schreiber (@SchreiberLars) writes about the Pitfalls with Table.ColumnsOfType
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- Phil Seamark (@PhilSeamark) blogs about DAX Fusion
- On the SQLBI blog, Marco Russo (@marcorus) highlights his presentation: My Power BI Report is Slow – What Should I Do?
- Paul Turley (@paul_turley) writes about the Power BI Product Suggestion: Show Measure Dependencies
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the Power BI blog, Christopher Finlan (@cmfinlan) shares the Paginated Reports August 2019 Feature Update – Report Builder Update, SaaS embedding support and whats coming soon and highlights the Free sample Power BI paginated report – Ultimate Export Report available for download
- On the Power BI Tips and Tricks blog, Steve Campbell writes about Dynamic Visuals using Buttons
- On the MSSQLTips site, Scott Murray discusses the Power BI Performance Analyzer
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- Marc Lelijveld (@MarcLelijveld) posts Storytelling with Power BI 3/7: Have a guided experience
- Patrick Leblanc (@patrickdba) explains How to create and use a Power BI Hierarchy
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- Brett Powell (@BrettPowell76) writes about the Power BI Paginated Premium Metrics Report
- Gilbert Quevauvilliers (@GilbertQue) discusses Using Version Control with Power BI Desktop Files, check in, check out, view or revert to previous versions | Part 2
- On the MSSQLTips site, Eduardo Pivaral (@EduardoDBA) explains how to Publish Power BI Report to Power BI Service
- On the Power BI Community blog, Michal Dvorak (@nolockcz) writes about The Last Timestamp of Loading Data
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 July 2019 feature summary
- On the Power BI YouTube channel, Christian Wade (@_christianWade) provides a 2019 release wave 2 overview
- Adam Saxton (@guyinacube) posts Power BI is killing it, developer updates, a contest and more (August 5, 2019)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 112 Changing the laws of Physics with Christian Wade
- On the Power BI community blog, jfeil explains how to Get Your Power BI Community User Group Member Badge
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.