Power BI Weekly Issue 235: 29th November 2023
No official announcements this week after the Ignite influx, although Darren Gosbell has shared the v3.0.10 Release of DAX Studio with a couple of updates and a bunch of fixes - so upgrade if you can! Otherwise, Sandeep Pawar has written a useful blog about Controlling Direct Lake Fallback Behavior, Alberto Ferrari has described how to Compute accurate percentages with row-level security in Power BI, and Bas Dohmen has shared an engaging introductory video about the New Button Slicers in Power BI.
Oh, and you may have seen that the SQLBits team has started announcing some of the training days that are going to be held on Tuesday 19th March next year at the start of the conference which runs up until Saturday 23rd. I'm very pleased to announce that my colleague Barry Smart and I will be presenting the training session DataOps: How to Deliver Data Faster and Better with Microsoft Cloud, talking about what you can do to bolster your data platform in the cloud. We'd love to see you there!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chandeep Chhabra (@chandeep2786) describes how to Master M Language in Power Query and describes How to Think & Write Complex M Easily Power Query Case Study
- Reid Havens (@HavensBI) describes #PowerQueryEverything with Copilot for Data Factory (with Alex Powers)
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Darren Gosbell (@darrengosbell) announces v3.0.10 Release
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Computing accurate percentages with row-level security in Power BI
- Chris Webb (@cwebb_bi) writes about IF, SWITCH And The Effect Of DAX Variables On Strict/Eager Evaluation
- Sandeep Pawar (@PawarBI) describes Controlling Direct Lake Fallback Behavior
- Max Wikström (@maxwiks) covers Mastering DirectQuery in Power BI: A Deep Dive into Performance Optimization – Part 2
- Matt Allington (@ExceleratorBI) writes about Why Did Microsoft Rename Datasets to Semantic Models?
- P3 Adaptive (@P3Adaptive) write about What is the difference between Tableau and Power BI data model?
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) writes about Calculated Columns and Measures in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bas Dohmen (@HowToPowerBI) talks about the New Button Slicers in Power BI | 3 Examples You Don’t Want to Miss
- On the Learning Science YouTube channel, Learning Science explains How to dynamically change legend for visuals in Power BI
- Audrée Pellerin (@lecfomasque) covers Suivez vos indicateurs de performance clés (KPI) dans Power BI [French]
- On the Power BI community blog, Kumail Raza writes about Natural Language Query (NLQ) with Power BI: A powerful new way to interact with your data
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Vahid Doustimajd (@VahidDoustiM) shares Unraveling the possibility of Page-Level Security in Power BI - Hossein Seyedagha - (Persian)
- Reid Havens (@HavensBI) covers Introducing PowerOps (A New Productivity Tool for Power BI Developers)
- On the PowerPivotPro blog, P3 Adaptive (@P3Adaptive) cover Power BI Online
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 268 - Power BI November 2023 Feature Summary part 1
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.