Power BI Weekly Newsletter Issue #247

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sibling newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• On the Power BI blog, Ancy Philip (@ancyphilip) announces the deprecation of creation of machine learning models in Power BI using Dataflows V1
• Reid Havens (@HavensBI) explains how to Create your own Power Query Connector for Power BI & Dataflows (with Miguel Angel Escobar)
• On the Power BI community blog, Tianyi Chang explains how to Explore Web.Page in power query: Execute regular expressions with JavaScript
• Hima Bindu Marri (@sivahimabindu) describes Custom column vs Conditional Column in Power BI

Data Modeling

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• On the Power BI blog, Zoe Douglas (@MSPowerBI) covers Leveraging pure Direct Lake mode for maximum query performance
• Chris Webb (@cwebb_bi) blogs about dataCoverageDefinition: A New Optimisation For Hybrid Tables In Power BI
• On the Tabular Editor blog, Daniel Otykier (@DOtykier) writes about Tabular Editor 3: February 2024 Release
• Kurt Buhler (@kurtbuhler) writes about What Microsoft Fabric means for your semantic models: New options and approaches and on the Tabular Editor blog, explains how to Create semantic model relationships
• Reid Havens (@HavensBI) presents Power BI Semantic Model Best Practices (PIMP) Script (with Alexander Korn)
• On the Power BI community blog, Nirav Dangar discusses Creating Custom Calendars for Accurate Working Day Calculation in Power BI
• On the Business Intelligist blog, Business Intelligist (@bizintelligist) discusses Streak Analysis – From DAX to Reporting
• Neeko Tang describes How to perform calculations involving overall values under RLS constraints
• On the Power BI community blog, Arul blogs about Substring Occurrence Analysis Using DAX in Power BI
• Hafeez Jimoh (@jimohhafeezco) shares a number of videos: Introduction to Measures and DAX in Power BI, Explicit Measures with DAX in Power BI, Reporting and Storyboarding for measures in Power BI, Time Intelligence Measures in Power BI and Improve Performation for measures with Variables in Power BI

Report Authoring and Interactivity

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) announces Visual calculations (preview)
• Marc Lelijveld (@MarcLelijveld) writes about Exploring Power BI Visual Calculations
• Bas Dohmen (@HowToPowerBI) covers DAX Revolution? Visual Calculations in Power BI
• On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about Visual Calculations in Microsoft Power BI Desktop Version | Examples
• Also on the Power BI blog, Miguel Myers (@myersmiguel) announces Additional enhancements for columns, bars and ribbons
• Also on the Power BI blog, Carly Newsome (@MSPowerBI) introduces the Public Preview Copilot for Power BI chat-based capabilities: summarize, inquire, analyze
• Reid Havens (@HavensBI) describes how to Level Up your Power BI Game with Field Parameters (with Nikola Ilic)
• On the Power BI community blog, Yang Liu explains How to dynamically select the default values we need in a slicer in Power BI
• Andrzej Leszkiewicz (@avatorl) blogs about IBCS and data labeling in interactive Power BI reports
• On the Learning Science YouTube channel, Learning Science describes How to add multiple data labels for a column chart or any other visuals in Power BI
• Hafeez Jimoh (@jimohhafeezco) discusses Data visualization and Reports design process in Power BI
• Roland Szirmai (@BILAnalytics) explains how to Elevate Your Data Visualisation in Power BI with Scientific Design Techniques
• Dhruvin Shah (@DhruvinShah16) presents Mastering Python Visuals Creation in Power BI (with Dr. Gomathi S)
• Sam McKay (@_EnterpriseDNA) covers Increasing Your Development Speed & Productivity In Power BI

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, Kay Unkroth (@MSPowerBI) announces Announcing general availability of granular access control for all data connection types
• On the Power BI blog, Rui Romano (@RuiRomano) announces TMDL in Power BI Desktop developer mode (Preview)
• Also on the Power BI blog, Dustin Askins shares the Improvements to Power BI apps, an increase in audiences and access control for hidden content
• Kevin Chant (@kevchant) discusses Upgrading an existing Power BI Project to include TMDL file format

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, Saveen Reddy (@MSPowerBI) announces Power BI February 2024 Feature Summary
• Miguel Félix covers Atualização Power BI fevereiro 2024 [Portuguese]

Useful Links

• Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more