Power BI Weekly
Issue #96 - 9th February 2021
A feature I highlighted on the release plan last week is now available in preview, and that's Power BI Embedded Generation 2. Note that you can't currently upgrade Gen1 capacities to Gen2, but that will be automatic upon GA (estimated in July). Keeping on the Embedded theme, Adam Saxton has shared the New Contoso Sample app for Power BI Embedded, showcasing many of the alluring cutomisation features of Power BI Embedded, written in React & Typscript on the client side and C# (.NET 5) on the server side. A great starting-point for your Embedded apps.
Elsewhere this week, the Power BI team has written a comprehensive set of Best practice rules to improve your model's performance, all the way from DAX Expressions to naming conventions. Meagan Longoria has described how to grant ADLS Gen2 Access for Power BI Users via ACLs, and Chris Webb has continued his series on importing data from ADLS Gen2, writing about The Performance Of Importing Data From ADLSgen2 Common Data Model Folders In Power BI.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) discusses Testing The Performance Of Importing Data From ADLSgen2 Common Data Model Folders In Power BI
- Krešimir Ledinski (@Exceed_ltd) describes how to Dynamically expand table or record columns in Power Query
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) explains how to Remove duplicates in a text string with Power Query / Power BI
- Matthew Peterson (@mattpetersonbi) shares a Best Practice To Trim Before Removing Duplicates or Merging In Power Query Editor
- Chandeep Chhabra (@chandeep2786) describes a Nested LET Statement in Power Query
- Ruth Pozuelo Martinez (@CurbalEN) describes How to conditional merge tables in Power Query
- On the Towards Data Science blog, Octavio Bomfim Santiago explains How to use Machine Learning in Power BI with R
- Bas Dohmen (@HowToPowerBI) writes about EXCHANGE RATES in Power BI
- On the Blue Granite blog, Sam Edelstein writes about Power BI For Government Agencies - Connect and Store Data Part 2
- Wolfgang Strasser (@wstrasser) shares the Data Types Conversion Matrix in Power Query
- Marcus Wegener (@PowerBIler) shares Hey Peter! Power BI Datenquelle mit mehr als 10.000 Tabellen [German]
🧩 Data Modeling
- On the Power BI blog, Michael Kovalsky shares some Best practice rules to improve your model's performance
- Matt Allington (@ExceleratorBI) blogs about Power BI Calendar Tables
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) introduces DEFINE TABLE in DAX queries
- Parker Stevens (@PowerBIElite) talks about Simple Moving Averages (SMA) in Power BI
- Sam McKay (@_EnterpriseDNA) talks about Harvesting A Slicer Selection Within A DAX Measure For Dynamic Calculations
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) writes about Progressive Discount (Tax or Commission) Calculation (Power BI DAX Tutorial)
- Martin Schoombee (@MartinSchoombee) blogs about Fixing incorrect drill-through results in Analysis Services – Part 2
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) explains how to Explore Azure Analysis Services Model and Data
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #195: 🔥 53 DAX Best Practices 🔥
- Hima Bindu Marri (@sivahimabindu) describes Building Relationships in Power BI
📊 Report Authoring and Interactivity
- On the Power BI community blog, Pragati Jain talks about Custom Date Formats in Power BI Using a Slicer
- Adam Saxton (@GuyInACube) delves into Power BI slicers vs the filter pane
- Reid Havens (@HavensBI) talks about Creating Sliding Toggles With Native Buttons in Power BI and discusses Enterprise Power BI Templates – Work Smarter Not Harder (with Mike Carlo)
- On the MSSQLTips site, Fikrat Azizov explains how to Build Appealing Dashboards using Azure Synapse Analytics
- Hima Bindu Marri (@sivahimabindu) talks about Custom tooltip in Power BI and describes How to Use Drillthrough in Power BI
- Alex Badiu (@BadiuAlexandru) describes how to Highlight Key Points In Scatter Charts - Compelling Data Viz Technique In Power BI
- Greg Philps explains How To Display Dynamic Narratives For Interactive Data
- The Power BI team (@MSPowerBI) describes How to use Anomaly Detection to enhance your line charts
- Also on the MSSQLTips site, Kenneth A. Omorodion discusses Power BI Reports with Animated GIF
- Bas Dohmen (@HowToPowerBI) writes about Dynamic Titles based on slicer selection in Power BI
- Philipp Lenz (@lenz_philipp) talks about Translation of your Power BI Embedded Report (App owns data)
🚀 Deployment, Security and Operations
- On the Power BI blog, Alon Baram announces Power BI Embedded Generation 2 (preview)
- On the Access Analytic blog, Wyn Hopkins (@wynhopkins) talks about Power BI & Teams – granting access
- Meagan Longoria (@mmarie) walks through Granting ADLS Gen2 Access for Power BI Users via ACLs
- On LaDataWeb, Josefina Depetris writes Actualizar PowerBi con ServicePrincipal [Spanish]
🌐 General
- Adam Saxton (@GuyInACube) highlights the New Contoso Sample app for Power BI Embedded
- Adam Saxton and Patrick Leblanc (@GuyInACube) shares 🔴 Power BI tips from the Pros – LIVE (Feb 6, 2021)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present 178 - Power BI 2021 Release Wave 1 Roadmap review