Power BI Weekly Issue 19: 6th August 2019
Three main updates for you all this week. The Power BI Developer community June & July update has been shared with us, in which we've been told that the use of service principals with the API is now GA, and that Paginated Reports can now be embedded into internal applications (plus plenty more updates). We've also been told about the New Power BI Region in South Africa and the Power BI "Back to School" Contest, whereby entrants submit a Power BI-powered lesson to educate students through the fun and interactive medium of Power BI.
Elsewhere this week, Chandeep Chhabra has taken us through the various DAX Keyboard Shortcuts to help us navigate the function pane more efficiently, and David Eldersveld has written about Data Sonification in Power BI, for those of you wanting/needing to add some audio to your reports.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Get Images from Web Page Into the Power BI Report Using Power Query
- Gerhard Brueckl (@gbrueckl) talks about Data Virtualization in Microsoft Power BI
- On the Excelguru blog, Ken Puls (@kpuls) introduces Power Query Challenge 6 and provides some Solutions
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) blogs about Grouping rows with Power BI / Power Query
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Some Simple Ways to Debug Your DAX Measure Code in Power BI: Debugging Virtual Tables
- Chandeep Chhabra (@chandeep2786) talks about DAX Keyboard Shortcuts
- Matt Allington (@ExceleratorBI) describes The FILTER Function in DAX Part 2
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few blogs: Analyze Who Your Lost Customers Are Using Power BI & DAX, How To Allocate Results To Templates At Every Single Row Using Power BI, Showing Actual Results vs Targets Only To Last Sales Date In Power BI and on the Power BI community blog, How To Deal With Multiple Dates In Power BI
- Carl de Souza (@carldesouza) describes Using the GENERATESERIES DAX Function in Power BI
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- David Eldersveld (@dataveld) discusses Data Sonification in Power BI
- Marc Lelijveld (@MarcLelijveld) writes Storytelling with Power BI 2/7: Be dynamic
- Meagan Longoria (@mmarie) tells us to Check Out the Updated Violin Plot Power BI Custom Visual
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- Gilbert Quevauvilliers (@GilbertQue) discusses Does the New Look Power BI Service use more or less report page screen real estate?
- Gil Raviv (@gilra) explains how to Find overlapping time periods using PowerQuery – Part 3 Fast & Furious
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, David Magar announces the New Power BI Region in South Africa
- On the Power BI community blog, Jayendran Arumugam writes about Gateway Monitoring & Administrating- Part 1 and Part 2
- Patrick Leblanc (@patrickdba) discusses Siri Shortcuts with Power BI Mobile for iOS
- Roberto Stefanetti (@robstefane) reminds us that from September 1, 2019, content packs are no longer supported on Power BI online
- On the Blue Granite blog, Melissa Coates (@SQLChick) explains Why Power BI Shared Datasets are Critical to a Self-Service BI Implementation
- Carl de Souza (@carldesouza) explains how to Classify Your Data with Power BI Dashboard Data Classification
- On the MSSQLTips site, Dinesh Asanka walks through Monitoring SQL Server Analysis Services with Extended Events
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Sujata Narayana announces Power BI "Back to School" Contest
- Also on the Power BI blog, Alon Baram provides the Power BI Developer community June & July update
- David Eldersveld (@dataveld) shares the Power BI Blogmap at PowerBI.World
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 111 July 2019 Power BI Desktop Update
- Adam Saxton (@guyinacube) presents A new look for Power BI, notifications, Tooltips and more... (July 29, 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.