Power BI Weekly Issue 160: 7th June 2022
Only one update this week, which is that Enhanced refresh with the Power BI REST API is now generally available (renamed from asynchronous refresh for those wondering).
Elsewhere this week, Glyn Jones has described How to grant Power BI Service Workspace access using PowerShell, Philipp Lenz has provided a brief first look to Power BI Datamarts, and Kelly Kaye has hosted The Power BI Community Show Ep 6 talking about recent Power BI Event Updates with guest Will Thompson.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Philipp Lenz (@lenz_philipp) provides A first look to Power BI Datamarts
- Adam Saxton (@GuyInACube) discusses Power BI dataflows vs datamarts: What's the difference? and talks about Answering your datamart questions
- Olivier Travers (@otravers) describes Connecting to Power BI Datamart's SQL Server from Desktop Tools and External Services
- Ruth Pozuelo Martinez (@CurbalEN) discusses Will datamarts become the online version of Power BI Desktop?
- On the Power BI community blog, Vijay Verma covers Date.Networkdays.Intl in Power Query Language M
- Excel University highlights Excel University's Top 5 Power Query Tutorials
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) talks about Power Query Data Structure: Table, Record, List
- Rick de Groot (@Rickmaurinus) explains how to Create Index Column By Group in Power Query
- Brian Julius and Melissa de Korte (@_EnterpriseDNA) present Practical Power Query Solutions - Nested Structured Values (Part 1)
- Kim Leblanc describes how to Se connecter à une procédure stockée SQL avec Power Query [French]
- Alex Powers (@notaboutthecell) presents Power BI Dev Camp Session 22 - Custom Functions and Documentation in Power Query with Alex Powers
- On the Prologika blog, Teo Lachev (@tlachev) announces Atlanta MS BI and Power BI Group Meeting on June 6th (How Power Query Thinks)
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Philipp Lenz (@lenz_philipp) describes Comparison with DAX by selecting two different time ranges
- On the MSSQLTips site, Kenneth A. Omorodion describes DAX Rounding Functions for Power BI Reports
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about DATESINPERIOD – DAX Guide and discusses FIRSTNONBLANK, LASTNONBLANK, FIRSTNONBLANKVALUE, LASTNONBLANKVALUE – DAX Guide
- On the Prologika blog, Teo Lachev (@tlachev) provides A Case for Azure Analysis Services
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Daniel Marsh-Patrick (@the_d_mp) announces Deneb 1.3 Beta-2 Available
- Gerhard Brueckl (@gbrueckl) writes about Using Power BI Field Parameters to translate Data and Values
- Gilbert Quevauvilliers (@GilbertQue) explains How Power BI Field Parameters works under the hoods
- Reid Havens (@HavensBI) discusses Adding Dynamic (Model Refresh) Names to Field Parameters and talks about Optimizing Your Report with the Report Analyzer Tool (with Michael Kovalsky)
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) talks about Power BI inside PowerPoint: New Update on MS Build 2022
- Dhruvin Shah (@DhruvinShah16) describes how to Export Formatted Data Tables to Excel in Power BI
- James Andrew describes Adding Scrollbars to your Power BI Report | Create a Web App Design within your Data Reporting
- On the Learning Science YouTube channel, Learning Science describes Popup Window on Visual Tooltips in Power BI
- Winni Zhang blogs about The R code didn't result in creation of any visuals
- Bas Dohmen (@HowToPowerBI) describes how to Upgrade Your Report Design in Power BI | Complete Walkthrough From A to Z
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Ogbemi Ekwejunor-Etchie announces Enhanced refresh with the Power BI REST API is now generally available
- On the Power BI community blog, Mahak Rathore describes How to Add/Change Deployment Pipeline's Admin in Power BI if Do Not Have Access Due to Limitation
- On the SQL Server Central blog, Glyn Jones describes How to grant PowerBI Service Workspace access using PowerShell
- Neil Hambly (@Neil_Hambly) presents Power BI Licensing and Features (Webinar)
- Chris Webb (@cwebb_bi) explains how to Build Web Sites And Embed Power BI Reports In Them Using Power Pages
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show Ep 6 - Power BI Event Updates
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 227 - Interview with Treb Gatte about Power BI metrics
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.