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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.