Power BI Weekly Issue 26: 24th September 2019
Half a year's worth of issues already. Thank you to everyone who has subscribed, and those that regularly check the newsletters out on the website! Keep spreading the good word :) Anyway, here are the two main announcements from the Power BI team this week:
- Paginated Reports in Power BI September 2019 Feature Summary
- On-premises data gateway September 2019 update is now available
There have also been a few updates to Azure Analysis Services - see those further down the newsletter, or have a look on the Azure Updates site.
Elsewhere this week, Lars Schreiber has written about Tables in Power Query – how, when and why, and Matt Allington has announced the free upcoming webinar: Introduction to DAX for Power BI, so be sure to check that out!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to Only Get the Last Few Periods of Data into Power BI using Power Query Filtering
- Abu Hasan writes about Multiple replacements in a Column using Power Query
- On the Power BI community blog, Michal Dvorak (@nolockcz) writes Power Query Enter Data Explained
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) blogs about The Get Data User Experience in Power BI / Power Query
- Lars Schreiber (@SchreiberLars) talks about Tables in Power Query – how, when and why
- On the Excelguru blog, Ken Puls (@kpuls) writes that Column Quality and Distribution Features are Finally Here
- Gilbert Quevauvilliers (@GilbertQue) writes about Power Query – Getting the Min Value repeated for all rows in my table
- The Azure updates team provides a number of AAS updates: Improved query replica synchronization in Azure Analysis Services is in development, Azure Analysis Services scale-out improvement, Azure Analysis Services—Two new higher compute SKUs are now available and Azure Analysis Services diagnostic logging improvements for scale-out
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about the ALL Function in Power BI – How To Use It With DAX and walks through Ranking Insights Using TOPN In Power BI
- Matt Allington (@ExceleratorBI) highlights the Free Webinar: Introduction to DAX for Power BI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) writes about Strong and weak relationships in Power BI
- Patrick Leblanc (@GuyInACube) describes how to Use other tools with the Power BI data model
- Chandeep Chhabra (@chandeep2786) writes about the RELATED Function Not Working
- Daniil Maslyuk (@DMaslyuk) covers TRIMMEAN in DAX
- Chris Webb (@cwebb_bi) discusses Power BI Custom Format String Examples, Part 2: Dates And Times
- On the PowerPivotPro blog, Rob Collie (@robcolli3) provides A Brief Treatment of DIVIDE(), RANKX(), and “N/A”
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the edureka blog, Komal walks through Everything You Need To Know About Power BI Charts
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- Adam Saxton (@GuyInACube) describes how to Export data with Power BI Paginated URL Parameters
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 September 2019 update is now available
- Brett Powell (@BrettPowell76) talks about Power BI Premium Registered Servers
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) discusses Updating PBIX Files in SharePoint: Do's & Don'ts
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Christopher Finlan (@cmfinlan) provides the Paginated Reports in Power BI September 2019 Feature Summary
- Adam Saxton (@GuyInACube) talks about Football, Power BI Desktop update and more... (Roundup | September 16, 2019)
- Patrick Leblanc (@GuyInACube) discusses The new Power BI Mobile look (September 2019)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 118 - September 2019 Power BI Desktop Update
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about the Power BI Training Self Assessment: What Training Path Should I Take?
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) talks about Power BI Workbooks vs Datasets
- Nicky van Vroenhoven (@NickyvV) writes about the Power User Days Belgium - September 2019 Edition
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.