Power BI Weekly Issue 27: 1st October 2019
This week, the winners of the "Back to School" contest were announced - well done to David Eldersveld for winning with his interactive periodic table of elements. Two other updates this week: we've been told that Template apps update (preview) is now available and we've been given the Power BI Report Server September 2019 Feature Summary.
Elsewhere, Roque Leal has written about Bringing data to life using the Mapbox visual plug-in for Power BI. Plenty of colours and interesting insights in that blog. Also, Charles Sterling has written about using PowerApps to update and refresh data in Power BI and Eugene Meidinger has provided A comprehensive guide to Power BI performance tuning.
Finally, today and tomorrow it's Microsoft's Future Decoded event in London. The whole of the endjin team will be there, so if you want to say hi, come and find us camped out in Costa!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Generate Random List of Numbers in Power BI Dataset Using Power Query
- Chris Webb (@cwebb_bi) writes about Hierarchical Navigation For Azure Data Lake Storage Gen2 In Power BI/Power Query
- Patrick Leblanc (@GuyInACube) covers Query Dependency in Power Query / Power BI Desktop and Adam Saxton talks about Power BI dataflows: One thing you probably missed with your gateway
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) covers Using PowerApps dataflows and the PowerApps add-in for Excel
- Brett Powell (@BrettPowell76) discusses Analysis Services DMVs in SSMS
- On the Visual BI blog, Parkavi Parameswaran blogs about Power BI Datasets in Paginated Reports for Pro Users
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the Power BI Tips and Tricks blog, Steve Campbell covers a Custom Sort Order Within a DAX Measure
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the RADACAD blog, Reza Rad (@Rad_Reza) covers Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains How to Control The Interactions Of Your Visuals In Power BI
- Meagan Longoria (@mmarie) talks about Power BI for Communication and Marketing
- Patrick Leblanc (@GuyInACube) discusses Using Custom Format Strings in Power BI Desktop
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) covers Grouping with Style
- Charles Sterling (@chass) describes PowerApps to update and refresh data in Power BI Hands On Lab and blogs about Creating dynamic Power BI tiles inside of PowerApps
- On the Visual BI blog, Helena David writes about the Linear Gauge- Custom Visuals for Microsoft Power BI
- Also on the Visual BI blog, Sathya Narayana Karthikeshwar (@karthikeshwar) explains how to Edit Variables for End Users in Power BI
- Roque Leal writes about Bringing data to life with PowerBI
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) talks about Sorting Dates By Financial Year In Power BI, covers Predicting When Will Your Customers Purchase Next w/Power BI and writes about a Last Purchase Date in Power BI: When Did Your Customers Make Their Last Purchase
- Matt Allington (@ExceleratorBI) writes Is my Power BI Report Filtered?
- Marc Lelijveld (@MarcLelijveld) writes Storytelling with Power BI 7/7: Let them ask questions
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, Teddy Bercovitz (@Teddybbb) announces that Template apps update (preview) is now available
- Gilbert Quevauvilliers (@GilbertQue) blogs about Using Power BI Support to create a Support Ticket
- Imke Feldmann (@TheBIccountant) writes about Power BI administration made easy with Power BI REST API custom connector
- Matthew Roche (@SQLAllFather) writes that Governing Power BI just got a little easier
- Eugene Meidinger (@sqlgene) provides A comprehensive guide to Power BI performance tuning
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 writes Congratulations to the Winners of the "Back to School" Contest! and provides the Power BI Report Server September 2019 Feature Summary
- Adam Saxton (@GuyInACube) covers Power BI Paginated, relationships and more... (Roundup | September 23, 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.