Power BI Weekly
Issue #214 - 4th July 2023
No official announcements this week, but Darren Gosbell has shared the v3.0.8 Release of DAX Studio, including improved metadata refresh for Fabric Direct Lake models, and the ability to include dynamic format strings within the DEFINE MEASURE syntax. Otherwise this week, I've actually started a video series showcasing an end-to-demo Fabric demo, with Part 1 - Lakehouse & Medallion Architecture and Part 2 - Inspecting 28 Million row dataset already released, a new episode coming out this week, and plenty more over the next few weeks covering Data Engineering Notebooks, OneLake and Power BI. Finally, a bit of Power BI specific content this week - as ever, Bas Dohmen has shared a great tutorial video describing how to Cross-highlight Scatterplots instead of cross-filter alongside a couple of other cool visual tricks.
🛠️ Data Prep
- Patrick Leblanc (@GuyInACube) asks Can you use Power Query Dynamic M Parameters for multi-select
- Sandeep Pawar (@PawarBI) describes Fabric : Not All Delta Table Are Created Equally and talks about Fabric : Not All Delta Tables Are Created Equally
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power BI Direct Lake – What is it and Why it is Important When Working With Fabric?
🧩 Data Modeling
- Darren Gosbell (@darrengosbell) highlights v3.0.8 Release
- Patrick Leblanc (@GuyInACube) explains how to Create MEANINGFUL data labels with measures in Power BI
- Chandeep Chhabra (@chandeep2786) explains How to Use Measures as Columns Using Calculation Group in Power Bi
- Vahid Doustimajd (@VahidDoustiM) describes One click to unveiling the Hidden Codes: Extracting all Measures from Power BI Service
- Avi Singh (@powerbipro) describes How to Write any DAX Measure In Just 3 Easy Steps
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) talks about TOPN in Power BI
- On the SQL Server Central blog, G_M_J describes How to Reduce the Need for Bookmarks Using Parameters in Power BI
- Ignacio Barrau (@ignacho_07) shares a video on Advanced Scripting [Spanish]
📊 Report Authoring and Interactivity
- Bas Dohmen (@HowToPowerBI) talks about Scatterplot - Cross-highlight instead of cross-filter
- On the Perficient blog, Rohit Rinayat writes about AI Insights and Visuals in Power BI
- Andrzej Leszkiewicz (@avatorl) shares an International Business Communication Standards based chart
- Reid Havens (@HavensBI) presents an Engaging Q&A and Discussion with Amir Netz - Microsoft Fabric's CTO
- On the Learning Science YouTube channel, Learning Science talks about New Card Visual in Power BI
🚀 Deployment, Security and Operations
- Darren Gosbell (@darrengosbell) walks through Calling a Power BI REST API from a Fabric Notebook
- Chris Webb (@cwebb_bi) writes about On-Demand Loading Of Direct Lake Power BI Datasets In Fabric
- Christopher Finlan (@cmfinlan) writes about Advanced Power BI Data Security: Row-Level Security and Data Masking Strategies with Code Samples
- Just Blindbæk (@justblindbaek) writes about Widely shared Power BI reports
- Antriksh Sharma (@AntrikshShar) talks about Installing TOM Library to connect Python to Power BI &38 SSAS
- On the SQL Server Central blog, Temidayo Omoniyi (@mssqltips) covers Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security