Power BI Weekly
Issue #162 - 21st June 2022
The Power BI June 2022 Feature Summary has been released, including announcements such as the new format pane becoming GA, the new Data Hub (which is the evolution of the Datasets Hub) and that DirectQuery for Power BI datasets is now supported in Power BI Embedded. There's also more information on Service Principal profiles (a feature for ISVs providing multi-tenanted Embedded solutions) with Alon Baram presenting a video going into more detail regarding the Service Principal profiles feature. Aside from the feature summary blog, we've also been told about the Updates to full report attachments for email subscriptions in Premium Gen2.
Elsewhere this week, and ATTENTION ALL CONSULTANTS/B2B GUEST USERS, Adam Saxton has shown a means by which you can sign-in to Power BI Desktop as an external (guest) user, allowing you to do things like connect to datasets in a different tenant and publish to a different tenant's Power BI Service instance. This is huge news, and is thanks to AAD auth flow updates highlighted by Ross Couldrey. Also this week, Kurt Buhler has written a great, comprehensive blog detailing the Dimensions of Self-Service in Power BI: Part 2 - The Dimensions of Learning, and Eli Gascon has described Filtering unrelated tables in Power BI - a common requirement when working with slicers in Power BI.
🛠️ Data Prep
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) walks through Adding Pre Calculated Rank in Power BI Using Power Query
- Rick de Groot (@Rickmaurinus) covers Using the Text Format Function in Power Query
- Ben Gribaudo (@bgribaudo) writes about Custom Connectors: Populating Table.Schema
- Lars Schreiber (@SchreiberLars) writes Gestapelte daten transformieren [German]
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) covers Power BI Report Builder Expressions - Date Functions and describes Power BI Report Builder Expressions - Build In Fields and Functions
🧩 Data Modeling
- On the endjin blog, Elisenda Gascon (@elisendagascon) walks through Filtering unrelated tables in Power BI
- Bernat Agulló (@AgulloBernat) describes Creating well formatted measures based on a calculation group
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explains How to show more dates than selected in DAX
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR – DAX Guide and describes CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR – DAX Guide
- On the Learning Science YouTube channel, Learning Science describes How to calculate Year To Date (YTD) in Power BI using Dax
- Greg Deckler (@GregDeckler) explains How To Create Dynamic Temporal Scale In Power BI Pt.1
📊 Report Authoring and Interactivity
- Erik Svensen (@donsvensen) describes Using Field Parameters when connecting to a Power BI dataset or Azure Analysis Services
- Philipp Lenz (@lenz_philipp) provides A look to Power BI Power Automate Visual
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Create a chart with images in Power BI and describes how to Export from Power BI to Excel up to 100k rows
- Gilbert Quevauvilliers (@GilbertQue) describes Exporting a Power BI Visual data to a CSV File in SharePoint
- Reid Havens (@HavensBI) describes How to Use the Magic Effects (FX) Button in Power BI
- On the MSSQLTips site, Bhavesh Patel writes about Dynamic Page Navigation in Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Michael Bruhjell (@MSPowerBI) announces Updates to full report attachments for email subscriptions in Premium Gen2
- Adam Saxton (@GuyInACube) explains how to Publish from Power BI Desktop for External Users
- Alon Baram (@MSPowerBI) talks about Power BI Embedded: Service Principal Profiles.
- Ted Pattison (@TedPattison) announces Power BI Dev Camp June 2022 Promo - Writing Azure Functions to call the Power BI REST API
- Phil Seamark (@PhilSeamark) describes Using PowerShell to create Calculation Groups in Power BI Desktop
- On the Enterprise DNA blog, Brian Julius (@_EnterpriseDNA) writes about Power BI Automation With Elgato Stream Deck
- Chris Webb (@cwebb_bi) walks through Cancelling Power BI Dataset Refreshes With The Enhanced Refresh API
- Patrick Leblanc (@GuyInACube) talks about What tool do you use to optimize your Power BI dataset?
🌐 General
- On the Power BI blog, Oksana Kyrychenko announces Power BI June 2022 Feature Summary
- Ruth Pozuelo Martinez (@CurbalEN) discusses Feature summary for Power BI June 2022 update
- Miguel Félix covers Atualização Power BI Junho 2022 [Portuguese]
- Kurt Buhler (@kurtbuhler) writes about Dimensions of Self-Service in Power BI: Part 2 - The Dimensions of Learning
- On the Power BI community blog, Heather Hernandez announces Introducing the first-annual Microsoft Power Platform Conference
- On the MSSQLTips site, Sean Lee delves into Study material for Exam PL-300: Microsoft Power BI Data Analyst
- Arnaud Gastelblum (@LazySna1l) shares LazyDAX: a Power BI File for your presentation, discoveries, or learn DAX