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
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
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) 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
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- 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
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- 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
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
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.