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
- 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
- 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
- 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
- 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
- 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
- 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