Power BI Weekly
Issue #14 - 2nd July 2019
This week, we've received the Power BI Dataflows June 2019 Feature Summary, which has outlined the new dataflow templates, and the new enhanced compute engine which Matthew Roche has elaborated on here. What's more, we've finally been granted our wish of a Viewer Role for Power BI Workspaces, we've been given the Power BI Paginated Reports June 2019 Feature Update Summary, and we've been told how to Avoid workspace loops by expanding navigation properties in the GetGroupsAsAdmin API, by using the new $expand query option in the API call.
🛠️ Data Prep
- On the Power BI blog, Mohammad Ali (@mohaali45) provides the Power BI Dataflows June 2019 Feature Summary
- Also on the Power BI blog, Sabin Nair (@nair_sabin) introduces dataflow templates; A quick and efficient way to build your sales leaderboard and get visibility over your sales pipeline
- Matthew Roche (@SQLAllFather) provides a Status Check: Power BI dataflows and ADLSg2, talks about the Power BI dataflows enhanced compute engine and provides a Quick Tip: Power Query column by example
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) covers The future of Data Preparation: Interview with Miguel Llopis and Microsoft Power BI Dashboard in a Day Panam &
- On the Kohera blog, Frederik Aerts (@fre_vs_alpha) posts a How To video: Visualise your Fitbit data in Power BI
- Chris Webb (@cwebb_bi) writes about Q&A Buttons And Power BI Service Live Connections
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Using CONCATENATEX in measures
- Chris Webb (@cwebb_bi) writes that the DAX Median Function Does Not Work On Tables With More Than 2 Billion Rows
⚙️ Report Design and Visualizations
- On the Power BI blog, Christopher Finlan (@cmfinlan) covers Power BI Paginated Reports June 2019 Feature Update Summary
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 106 - Interview with Chris Finlan about Paginated Reports in the Power BI Service
- On the MSSQLTips site, Gauri Mahajan explains How to use Treemap Bar Chart visuals in Power BI Desktop
- On the Blue Granite blog, Lindsay Pinchot (@LindsayPinchot) discusses Power BI Performance: Simple Practices for Report Optimization
⚙️ Data Exploration
- On the Power BI community blog, Yasin Shtiui writes about Cost-Benefit Analysis using machine learning in Power BI
- Matt Allington (@ExceleratorBI) describes Filters on Power BI Slicers – Wait, What?
- On the DB Best blog, DeNisha Malone (@thepowerbiqueen) presents Power BI — Set Visual, Page, and Report Level Filters — Episode 13
- Kasper de Jonge (@kjonge) describes Showing only slicer data that have facts in Power BI (and other fun tricks)
🚀 Deployment, Security and Operations
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the New Viewer Role for Power BI Workspaces
- Also on the Power BI blog, Harjinder Raheja discusses Avoiding workspace loops by expanding navigation properties in the GetGroupsAsAdmin API
- Craig Porteous (@CPorteous) writes about REST API automation with PowerShell in Azure
- On the RADACAD blog, Reza Rad (@Rad_Reza) talks about Power BI Shared Datasets: What is it? How does it work? and Why should you care?
- Adam Saxton (@guyinacube) talks about Shared & Certified datasets in Power BI
- Gilbert Quevauvilliers (@GilbertQue) describes How to setup and get a Certified Dataset in PowerBI
- Devin Knight (@knight_devin) covers Setting Up Power BI Row Level Security
🌐 General
- Adam Saxton (@guyinacube) covers BYOK for Power BI Premium, Charticulator, customer stories and more (June 24, 2019)
- Devin Knight (@knight_devin) discusses Power BI Monthly Digest – May 2019 with Daniel Straitiff and discusses Power BI Monthly Digest – June 2019