Power BI Weekly Issue 248: 5th March 2024
This week we've had a few more announcements. Firstly is the the announcement around the retirement of legacy Power BI Apps (pre-audiences) (honestly I hadn't realized they'd branded pre-audience apps as "Legacy"). We've also been given a summary of the Updates and enhancements for reference labels including a handful of new improvements, and we've been told about the New Data Connectors for Excel and CSV for Report Creation in Fabric.
Elsewhere this week, Sandeep Pawar has written an interesting blog around Calculating and Reducing Power BI Dataset Size Using Semantic Link, Teo Lachev has shared A First Look at DAX Visual Calculations: the Good, the Bad, and the Ugly, and Reza Rad has taken us through the (relatively) new feature Power BI Dynamic Subscription: Send Scheduled Report Filtered for Everyone's Data Automatically.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the Power BI blog, Ikechukwu Edeagu (@MSPowerBI) announces the New Data Connectors for Excel and CSV for Report Creation in Fabric
- On the Power BI community blog, Junyan Tao explains how to Realize circular dependency columns using M function
- Chandeep Chhabra (@chandeep2786) explains how to Remove Promoted Headers Step With This Trick In Power Query
- On the Learning Science YouTube channel, Learning Science describes How to conditionally duplicate rows in Power Query using Power BI?
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Sandeep Pawar (@PawarBI) walks through Calculating and Reducing Power BI Dataset Size Using Semantic Link
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) delves into DAX limitations with inactive relationships and row-level security (RLS)
- Chandeep Chhabra (@chandeep2786) describes how to Use Excel to Build & Validate Complex DAX and describes a Clever Date Table Trick in Power BI you've got learn
- Audrée Pellerin (@lecfomasque) covers Power BI : Multiples colonnes de dates dans vos tables de faits [French]
- On the phData blog, Bhupathi Siva (@phdatainc) describes How to Build a Slicer with Preset Date Ranges in Power BI
- Luca Liu writes Understanding Nested IF vs. SWITCH in Power BI: A Comparative Analysis
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Miguel Myers (@myersmiguel) announces Updates and enhancements for reference labels
- On the Prologika blog, Teo Lachev (@tlachev) provides A First Look at DAX Visual Calculations: the Good, the Bad, and the Ugly
- Reid Havens (@HavensBI) covers Creating a Dual Variance Chart w/ Overlap + Error Bars in Power BI
- Bas Dohmen (@HowToPowerBI) describes 1 Trick for Endless Power BI Charts
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) covers Power BI Copilot In Action: Enhancing Analytics with AI?
- Tom Martens (@tommartens68) writes about Deneb - passing color values as measure value
- Hafeez Jimoh (@jimohhafeezco) talks about Interactions and tooltip in Power BI, describes Building Report Pages and covers Changing canvas color + Few other things
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, Jadelyn Ray (@MSPowerBI) shares Announcing the retirement of legacy Power BI Apps (pre-audiences)
- Philipp Lenz (@lenz_philipp) writes about Continuous deployment with Power BI and DevOps and Power BI Projects (PBIP)
- Nick Jeffries describes Ways to Configure RLS in Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power BI Dynamic Subscription: Send Scheduled Report Filtered for Everyones Data Automatically
- Chris Webb (@cwebb_bi) writes about Measuring The Total Time Spent Querying Sources In Power BI DirectQuery Mode
- Kevin Chant (@kevchant) writes about Initial tests to copy a Direct Lake semantic model to another workspace using Microsoft Fabric Git integration
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 257
- Mohammed Adnan describes Power BI - New Cool Features - You should Know
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.