Power BI Weekly Issue 230: 24th October 2023
The Power BI October 2023 Feature Summary was shared last Tuesday (even though the blog confusingly seems to indicate it was released a week prior). Anyway, we have some nice updates this time around, including: the ability to create a customized deployment pipeline of 2-10 stages (10 seems a bit extreme!), the ability to create Deduplication rules for composite models on Power BI Datasets and Analysis Services which gives you more control around how name conflicts are handled when connecting to multiple source datasets, and we've been told about various On-object Interaction Updates if that's the formatting method you prefer.
For those who may be interested, I'll be presenting at the Oxford Microsoft Data Platform Group next Wednesday at 6:30 GMT, demonstrating an End-to-End Solution in Microsoft Fabric for Data Engineers. I'll be followed by Adam Buckley who's going to show how to "Query your Azure SQL Data using Natural Language". It's a hybrid event, so you can join either in person or on Teams. Hope to see some of you there!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Kurt Buhler (@kurtbuhler) explains How to use Tableau with Power BI and Fabric
- On the Learning Science YouTube channel, Learning Science describes How to use Automated Machine Learning (AutoML) in Power BI
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Max Wikström (@maxwiks) blogs about Exploring the model pane in Power BI Desktop: A Hands-on guide
- Bas Dohmen (@HowToPowerBI) walks-through Exploring the Semantic Model in Power BI | October 2023 Update
- Adam Saxton (@GuyInACube) covers Finish the Puzzle: Querying Power BI Semantic Models with Semantic Link
- Kurt Buhler (@kurtbuhler) writes about Case-sensitive models in Power BI: consequences & considerations
- Reid Havens (@HavensBI) walks-through Folder Organization for Tables? Using Tabular Editor 3
- Chandeep Chhabra (@chandeep2786) describes 7 Simple Concepts of Writing Powerful DAX
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Chris Webb (@cwebb_bi) writes about Getting Report Visual IDs With Power BI Desktop Developer Mode
- Fowmy Abdulmuttalib (@ExcelFort) talks about Enhanced Bar Chart: A Better Alternative to Pie Chart in Power BI
- Chandeep Chhabra (@chandeep2786) describes how to Lock Objects in Power BI
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) discusses Power BI KPIs
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, Lee Benjamin (@MSPowerBI) announces Deployment pipelines – A customized pipeline is finally here!
- Also on the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway October 2023 release
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Ryan Majidimehr (@MSPowerBI) shares the Power BI October 2023 Feature Summary
- Miguel Félix covers Atualização Power BI outubro 2023 [Portuguese]
- Matthew Roche discusses Self service BI as a two-edged sword
- Avi Singh (@powerbipro) talks about What are the Key Components of Power BI?
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.