Power BI Weekly
Issue #232 - 7th November 2023
One announcement this week, and that's the new admin API to get insights into tenant setting overrides at capacity level, which is more of a "Fabric" announcement really, but is relevant for any P SKUs you may already have. I believe the only two settings that can be delegated at the moment are the "Users can create Fabric items" and "Data Activator" settings, but I can see how this new feature will be useful going forward for visibility.
Elsewhere this week: Gerhard Brueckl has now formally released the excellent Power BI-VSCode Extension which helps you with numerous Power BI-related tasks (both management layer and data layer); Marc Lelijveld has described an "unofficial" way you can Recover Your XMLA-Modified Power BI Dataset with These Git-Integration Steps; and Bas Dohmen has shown us yet another cool visual around displaying Status Tracking Data in Power BI.
🛠️ Data Prep
- Reid Havens (@HavensBI) covers Keeping Query Folding by Outsmarting Columns from Examples in Power Query
- Chandeep Chhabra (@chandeep2786) describes Insane Power Query Trick | Refer to an Intermediate Step from another Query and talks about 5 Surprising Power Query Tricks You Need to Know
- Rick de Groot (@Rickmaurinus) describes Creating Julian Day Numbers with Power Query M and writes about Converting between Julian and Gregorian Dates in Power Query
- Audrée Pellerin (@lecfomasque) covers Découvrez les filtres dynamiques dans Power Query [French]
- Nandan Hegde (@nandan_hegde15) explains how to Automated Way to Extract Data from Power BI Dataflow via MSFT Fabric
- On the phData blog, Gavin Pedersen (@gavin_PD) explains How to Parameterize Data Sources in Power BI
🧩 Data Modeling
- Chris Webb (@cwebb_bi) walks through Exploring Power BI Run-Length Encoding With DMVs
- On the MSSQLTips site, Sean Lee (@mssqltips) writes about Power BI DAX Functions - RANK and ROWNUMBER
- Philipp Lenz (@lenz_philipp) explains how to Write new measures with Chat GPT?
- Bas Dohmen (@HowToPowerBI) explains how to Update Power BI to October 2023 Version and Explore Semantic Model
- On the phData blog, Bhupathi Siva (@phdatainc) explains How to Create and Use Flags as Measures with DAX in Power BI
- Also on the phData blog, Dave Ovitt (@phdatainc) blogs about Getting Started with ALM Toolkit for Power BI
- Simon Harrison (@SelectDistLtd) covers Divide by Zero Errors
📊 Report Authoring and Interactivity
- Adam Saxton and Roseanne Levasseur (@GuyInACube) talks about Why On-Object Editing in Power BI?
- Bas Dohmen (@HowToPowerBI) delves into Visualizing Status Tracking Data in Power BI
- On the Learning Science YouTube channel, Learning Science talks about Dynamically change the measure when using the drill up and drill down visual functions in Power BI
- Simon Harrison (@SelectDistLtd) covers Unlock the Power of Geo Data
- On the MSSQLTips site, Harris Amjad (@mssqltips) covers Exploring New Card Visual in Power BI Desktop for Better Data Presentation
- Also on the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) explains How to Make Power BI Reports More Useful for End Users
🚀 Deployment, Security and Operations
- On the Power BI blog, Radhakrishnan Srinivasan (@MSPowerBI) announces Announcing a new admin API to get insights into tenant setting overrides at capacity level
- Gerhard Brueckl (@gbrueckl) blogs about Release of Power BI-VSCode Extension
- Marc Lelijveld (@MarcLelijveld) explains how to Recover Your XMLA-Modified Power BI Dataset with These Git-Integration Steps
- Dan English (@denglishbi) blogs about Power BI using Service Principal with Synapse SQL Pool with Shareable Cloud Connection
🌐 General
- Avi Singh (@powerbipro) explains how to Empower Your Sales Team with Power BI: For Emerging Beverage Brands with Mike Kazy
- Gilbert Quevauvilliers (@GilbertQue) blogs about Power BI Report for Microsoft Fabric Support Page