Power BI Weekly Issue 241: 16th January 2024
A couple of updates this week. The main one being that the Model explorer with calculation group authoring is now available in Power BI service including Direct Lake semantic models, further closing the gap between the Power BI Desktop model editing experience and the online editor. The second update is the Update to Dashboard Web Content tenant setting, whereby Microsoft has taken the decision to change this setting to be "off" by default due to security risks. Not entirely sure what happens when you've explicitly set this to "on" before now, so it's worth double checking if that's the case. Elsewhere this week, Lasse Malo has written a helpful blog for Excel users acquainting themselves with DAX, describing the differences in concepts and things to watch out for. Take a look in the blog Everything You Need To Know About DAX Coming From Excel Background.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) writes about What is Power BI Direct Lake Mode in Microsoft Fabric?
- On the Learning Science YouTube channel, Learning Science explains How to create a dimension table from a fact table in Power BI
- Ginger Grant (@DesertIsleSQL) talks about Fabric Features not found in Power BI or Synapse – Direct Lake
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the Power BI blog, Zoe Douglas (@MSPowerBI) announces Model explorer with calculation group authoring is now available in Power BI service including Direct Lake semantic models
- On the SQLBI blog, Marco Russo (@marcorus) talks about Circular dependencies and relationships – Unplugged #55
- Reid Havens (@HavensBI) presents Introducing DAX Optimizer (with Marco Russo)
- Chandeep Chhabra (@chandeep2786) describes the Best Way to Perform Like-for-Like Comparison in Power BI
- Brian Julius (@_EnterpriseDNA) describes Offset Magic: Make DAX Time Intelligence Disappear
- Max Wikström (@maxwiks) walks-through Optimizing Power BI: A Practical Guide to DirectQuery Performance – Part 3
- Lasse Malo writes about Everything You Need To Know About DAX Coming From Excel Background
- Meagan Longoria (@mmarie) covers Switching between different active physical relationships in a Power BI model
- On the Purple Frog Systems blog, Nick Edwards (@PurpleFrogSys) delves into Automating DAX Measure Formatting in Power BI with Tabular Editor
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bas Dohmen (@HowToPowerBI) walks through a Power BI Report Makeover | Combining All New Visualization Features
- Andrzej Leszkiewicz (@avatorl) describes Deneb and Vega - How to Start Learning Them and Why?
- DataChant Team (@datachant) describe GitHub Repository for Power BI Custom Visuals
- Daan Oosters (@daanoosters) writes Snel en eenvoudig low-code paginated reports bouwen [Dutch]
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, Harleen Kaur (@MSPowerBI) announces Update to Dashboard Web Content tenant setting
- Chris Webb (@cwebb_bi) writes about Understanding Blocking And Waiting In Power BI Import Mode Refreshes
- Marcus Wegener (@PowerBIler) covers Power BI Desktop Authentifizierungsfenster wird nicht geöffnet [German]
- Pat Mahoney (@mahoneypa) describes Bursting Paginated Report URLs With Power Automate
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
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.