Power BI Weekly Newsletter Issue #160

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

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

Useful Links

• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
• Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
• Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.