Power BI Weekly Issue 159: 31st May 2022
If you thought last week's edition contained all the announcements - you were wrong. So much more news came, such as:
- Composite models on SQL Server Analysis Services
- What's new in SQL Server 2022 Analysis Services CTP 2.0
- Power BI Report Server May 2022 Feature Summary
- On-premises data gateway May 2022 update is now available
alongside my particular favourites: the general availability of automatic aggregations, including integration with TOM and TMSL and incremental automatic aggregations training, and the general availability of the ExecuteQueries REST API, including ExecuteQueries support in Power Automate(!!). And last but certainly not least, away from the "official" announcements, Mathias Thierbach has announced preview support for Dataset deployment support in pbi-tools, including support for automatic refresh, Power Query parameters and more. See the recording from last week's Power BI Manchester meetup to see the new functionality in action.
Naturally, you'll notice that this week's edition contains a lot of content about Datamarts. Be sure to take a read through these to get some more views about the new feature, which (arguably) contain more interesting insights than the official blogs - like the fact that the automatic dataset that's generated is actually connecting to the SQL DB using DirectQuery, and that multiple users can edit the Datamarts UI at the same time. See:
- Dataflows with benefits - Matthew Roche
- First Look at Datamart - Mimoune Djouallah
- Power BI Datamarts First Impressions - James Fancke
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Adam Saxton and Patrick Leblanc (@GuyInACube) cover Exploring the preview of datamart in Power BI
- Matthew Roche (@SQLAllFather) writes about Dataflows with benefits
- Mimoune Djouallah (@mim_djo) writes about First Look at Datamart
- James Fancke (@jdfancke) provides some Power BI Datamarts First Impressions
- Olivier Travers (@otravers) blogs about Power BI Data: Dataset vs. Dataflow vs. Datamart vs. Dataverse vs. SQL Server vs. Synapse – Are You Confused Just Yet?
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) discusses Power BI Datamart – What is it and Why You Should Use it, describes Getting Started with Power BI Datamart, covers Power BI Datamart components and describes Power BI Datamart Integration in the Power BI Ecosystem
- Ruth Pozuelo Martinez (@CurbalEN) talks about What is a datamart? | Compared with data lakes, data warehouses & databases
- On the Blue Granite blog, Katy Young (@AStarIsBorg) explains how to Create End-To-End Self-Service Analytics With Power BI Datamarts
- Ben Gribaudo (@bgribaudo) describes New M Feature: Structured Error Messages
- On the Enterprise DNA blog, Hafiz Zubair Sultan writes about Query Folding And Connecting To SQL Server
- Rick de Groot (@Rickmaurinus) explains how to Transform Column Names in Bulk in Power Query
- Hima Bindu Marri (@sivahimabindu) explains How to improve the performance of Power BI report | Query folding
- Audrée Pellerin describes how to Utilisez vos flux de données Power BI dans Excel [French]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) announces Composite models on SQL Server Analysis Services
- Also on the Power BI blog, Zoe Douglas describes What's new in SQL Server 2022 Analysis Services CTP 2.0
- Also on the Power BI blog, Kay Unkroth announces Announcing general availability of automatic aggregations
- On the endjin blog, Jessica Hill blogs about Table Functions in DAX: DISTINCT
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers PARALLELPERIOD – DAX Guide, describes FIRSTDATE, LASTDATE – DAX Guide and covers DATESINPERIOD – DAX Guide
- Reid Havens (@HavensBI) describes DAX Anti-Patterns Episode Ten - Filter Columns Not Tables! (Part 2) - with Daniil Maslyuk
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about When a Count Goes Mad, or How to Count Orders over Time in DAX
- Imke Feldmann (@TheBIccountant) blogs about Forecasting with seasonality in Power BI
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show Ep 5 with Jeroen ter Heerdt - The Importance of Data Modeling
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Oksana Kyrychenko shares the Power BI Report Server May 2022 Feature Summary
- On the Learning Science YouTube channel, Learning Science talks about the Power BI Canvas Zoom
- Daniel Marsh-Patrick (@the_d_mp) writes about Deneb 1.3 Initial Beta Available
- On the PowerPivotPro blog, Mark Beedle (@markbdi) covers Completing the Set Up: Field Parameters Using Tabular Editor
- Miguel Félix covers Field Parameters [Portuguese]
- James Andrew explains how to Create and Customise a Single Value Slider in Power BI
- Ignacio Barrau (@ignacho_07) writes about Mensajes respaldando blancos [Spanish]
- David Abu (@DavidAbu_) covers Power BI and PowerPoint for Reporting and talks about Power BI in Microsoft Office
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Embed/ Add Live Power BI Reports in PowerPoint (Free Solution) and describes how to View your Power BI reports directly in Outlook! (the good and the bad)
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Miquella de Boer (@MSPowerBI) announces On-premises data gateway May 2022 update is now available
- On the Power BI blog, Kay Unkroth announces Announcing general availability of the ExecuteQueries REST API and announces Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate
- Reid Havens (@HavensBI) discusses Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API? (with Štěpán Rešl)
- Patrick Leblanc (@GuyInACube) explains how to Reduce the queries being sent with Incremental Refresh in Power BI
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) shares Using the Power BI Export API to Generate PDF and Image Files by Ted Pattison [User Group Recording]
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 226 - Power BI announcements from Microsoft Build 2022
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.