Power BI Weekly
Issue #163 - 28th June 2022
Not a huge amount of content this week, but we've had one pretty neat update which is that Preview data is now available in the dataset details page. You'll now see a pane on the right of your screen on the dataset details page with the tables and columns within the dataset, which you can use to take a quick peek at the data and export it if you wish (there's even a check-box at the table level to select all columns within that table (which still doesn't exist in Desktop, but oh well)). Elsewhere this week, Barry Smart has shown how Python and Power BI can work well together in his blog Extract insights from tag lists using Python Pandas and Power BI, Marco Russo has gone into depth helping us understand the optimization of SWITCH, and Kim Manis has joined Kelly Kaye on the Community Show talking about Synapse and Power BI.
🛠️ Data Prep
- On the endjin blog, Barry Smart covers Extract insights from tag lists using Python Pandas and Power BI
- Chris Webb (@cwebb_bi) blogs about Monitoring Power Query Online Memory And CPU Usage
- On the Power BI community blog, Xiaoxin Sheng describes How to do cumulative counting by group in Power Query
- Rick de Groot (@Rickmaurinus) describes how to Return Rows with Maximum Value in Power Query
- Michael Felix covers Rankings no Power Query [Portuguese]
- Bernat Agulló (@AgulloBernat) writes about Validating migrations, or how to properly compare tables
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) describes Power BI Datamart
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Understanding the optimization of SWITCH
- Greg Deckler (@GregDeckler) explains How To Create Dynamic Temporal Scale In Power BI Pt.2
- Reid Havens (@HavensBI) describes DAX Anti-Patterns Episode Twelve - Case Sensitivity - with Daniil Maslyuk
- On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) covers Using The DAX Studio User Interface: An Overview and writes about Optimizing DAX For Power BI Using DAX Studio – Formula Engines
- Olivier Travers (@otravers) describes How to Get DAX Query Results Out of Power BI Without Writing Any DAX or Code
📊 Report Authoring and Interactivity
- Daniel Marsh-Patrick (@the_d_mp) writes about "Out of One, Many", or: Making Switchable Charts in Power BI with Deneb
- Also on the Power BI community blog, Yingjie Li blogs about Field Parameters in Power BI
- On the Power BI community blog, Anand delves into Field Parameter and Bookmarking Field Parameter Values In Power BI Report Server
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes how to Bring life to Field Parameters in Power BI
- Also on the Towards Data Science blog, Thiago Carvalho writes about Dynamic Axes with Field Parameters in Power BI
- Kim Leblanc covers Libre choix à l’utilisateur avec les Paramètres de champs [French]
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes How to Add Forecasting in Line Chart | Regular and Irregular Intervals (Dates)
- Patrick Leblanc (@GuyInACube) discusses From Decomposition Tree to Details in Power BI
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) describes How to Increase the Vertical Orientation of Power BI Report Page
- James Andrew explains how to Create a stylish & minimal Power BI dashboard in 6 simple steps
- Ignacio Barrau (@ignacho_07) covers Informes preparados para exportar/imprimir [Spanish]
- On the Learning Science YouTube channel, Learning Science describes Hyperlink in Power BI | 4 Ways to add external URL & navigate in Power BI
🚀 Deployment, Security and Operations
- Cookie McCray announces Preview data is now available in the dataset details page
- Microsoft Power BI (@MSPowerBI) explain how to Govern your data in Power BI leveraging auto detection of sensitive information
- Marc Lelijveld (@MarcLelijveld) covers Power BI B2B External Collaboration
- Meagan Longoria (@mmarie) describes how to Log in to Power BI Desktop as an External B2B User
- Gilbert Quevauvilliers (@GilbertQue) describes How to get Power BI Row Level Security (RLS) Role users, details and export to CSV
- Arnaud Gastelblum (@LazySna1l) covers Filter a Power BI report passing parameters through URL
- Philipp Lenz (@lenz_philipp) explains how to Migrate SSAS Tabular Models to Power BI Premium by using the XMLA endpoint
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Append exported Power BI data to Excel automatically
🌐 General
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show Ep 7 - Synapse and Power BI with Kim Manis
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 229 - Power BI June 2022 Feature Summary
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) presents Power BI & Microsoft 365 – Better Together by Amanda Rivera Auckland Power BI User Group
- Bas Dohmen (@HowToPowerBI) explains How to Get Started with Power BI