Power BI Weekly Issue 15: 9th July 2019
Later on today (at 11AM PST), Christian Wade is hosting a live event to talk about the upcoming GA of Power BI Aggregations, an exciting feature enabling analysis over datasets consisting of trillions of rows. (Unfortunately I can't join this as I'll be attending the monthly London Power BI user group - let me know if you're going too!) Elsewhere, we've been told about the support for non-Premium Power BI datasets in Power BI Paginated Report Builder and that you can now have Multiple data source definitions on the On-premises data gateway for the same data source.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the Power BI blog, Kelly Kaye talks about Unlocking Petabyte-Scale Data Sets in Power BI with Aggregations – Upcoming General Availability
- Also on the Power BI blog, Christopher Finlan (@cmfinlan) announces support for non-Premium Power BI datasets in Power BI Paginated Report Builder
- On the Power BI community blog, Michal Dvorak (@nolockcz) describes Solving Real Life Problems with Recursive Functions in PowerQuery
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) also writes about Recursive Functions in Power BI / Power Query
- Marc Lelijveld (@MarcLelijveld) writes Don't let date columns ruin query folding in Power BI
- On the PowerPivotPro blog, Krissy Dyess discusses a Power Query Fail
- Gilbert Quevauvilliers (@GilbertQue) explains How to connect to your Power BI Premium Datasets using Excel (with the XMLA End Points)
- Matthew Roche (@SQLAllFather) blogs about Dataflows in Power BI: Overview Part 9 – Lineage and impact analysis, wonders Are you building a BI house of cards? and provides a Quick Tip: Implementing IsNumeric in Power Query
- Mark Smith (@nz365guy) writes Common Data Model Explained
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Budgeting Performance Segmentation Using DAX In Power BI
- Imke Feldmann (@TheBIccountant) explains how to Debug DAX variables in Power BI and Power Pivot
- Chandeep Chhabra (@chandeep2786) writes Find Trained Employees who Left – DAX Challenge
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) talks about Creating Basic Greater Than Or Less Than Rules With Power BI Conditional Formatting
- Matt Allington (@ExceleratorBI) discusses a Slicer with Histogram in Power BI
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes Quick Access Toolbar for the Win
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- Paul Turley (@paul_turley) writes a few related blogs: Drillthrough from Power BI to an SSRS Paginated Report, Drillthrough from Paginated Report to Power BI and Drillthrough Navigation Between Power BI and SSRS Paginated Reports
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) announces Multiple data source definitions on the On-premises data gateway for the same data source
- On the DataAP blog, Hariharan Rajendran provides a Power BI Inventory using Power BI REST API
- Adam Saxton (@guyinacube) talks about Power BI Apps vs App Workspace (the new Viewer role)
- On the Visual BI blog, Sathya Narayana Karthikeshwar (@karthikeshwar) writes Understanding Certified and Shared Data Sets in Power BI
- Roberto Stefanetti (@robstefane) provides some Power BI Deployment Reports Tips for Business Central Users
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- Adam Saxton (@guyinacube) discusses Power BI dataflows update, new viewer role, slicer filters and more (July 1, 2019)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 107 Power BI News & MVP Renewals
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.