Power BI Weekly
Issue #194 - 14th February 2023
A couple of announcements this week: we've been told about the administrative capability to Filter Power BI dataset usage in Excel by workspace using the updated Power BI Activity Logs, and how we can now Create stunning and more accessible reports in minutes with our new color themes which offers five new colour themes to cater for those around the world who have CVD (colour vision deficiency). Elsewhere, Imke Feldmann has described how to Reference an intermediate step from a different query in Power Query (were you aware of the meta keyword? I wasn't!), Chris Webb has shown an interesting way to achieve Dynamic What-If With User-Entered Data In Power BI, and Kurt Buhler has demonstrated the art of the possible by experimenting with Smart Buttons & Power BI Reporting.
🛠️ Data Prep
- Imke Feldmann (@TheBIccountant) describes how to Reference an intermediate step from a different query in Power Query
- Chris Webb (@cwebb_bi) covers Avoiding The “Maximum Allowed Size” Error In Power BI DirectQuery Mode With Aggregations On Degenerate Dimensions and writes about Dynamic What-If With User-Entered Data In Power BI
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) describes Power BI Between Dates Working Hours Solution
- Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) describes how to Use Cascading Parameters To Filter Data In Power BI Report Builder
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) describes how to Change the data source in Power BI
🧩 Data Modeling
- Reid Havens (@HavensBI) discusses [DAX] Best Practices 101 for Optimization & Performance (with Alberto Ferrari)
- Paul Turley (@paul_turley) writes about Creating and Displaying a Last Refresh Date Measure
- Patrick Leblanc (@GuyInACube) covers Time to look at the new INDEX function in DAX and Power BI
- Ignacio Barrau (@ignacho_07) covers [DAX] Time Intelligence vs WINDOW vs OFFSET [Spanish]
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes RANKX DAX Function In Power BI: A Comprehensive Overview, describes How To Get Totals Correct When Using Advanced DAX Logic In Power BI [2023 Update] and discusses Time Based Cohort Analysis - How To Setup Your Data Model In Power BI
- Brian Julius (@_EnterpriseDNA) describes How To Automatically Delete Unused Columns And Measures In Power BI
- Imke Feldmann (@TheBIccountant) describes how to Automatically plug or balance your balance sheet in Power BI
📊 Report Authoring and Interactivity
- On the Power BI blog, Sara Elizabeth Temby (@MSPowerBI) describes how to Create stunning and more accessible reports in minutes with our new color themes
- Reid Havens (@HavensBI) provides an Intro to Categorical Slicers & Options in Power BI and writes about Hidden Publish Defaults for Categorical Slicers in Power BI
- Kurt Buhler (@kurtbuhler) talks about Smart Buttons & Power BI Reporting
- On the Towards Data Science blog, Zoumana Keita (@zoumana_keita_) covers Everything You Need to Know About Heatmap - Tutorial With Power BI
- On the Learning Science YouTube channel, Learning Science describes How to add Search Bar in Power BI Slicer
- On the xViz blog, Xviz Coe (@xvizsuite) describes how to Visualise Task Dependencies in xViz Gantt Chart for Power BI
- Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) explains how to Create A Gantt Chart In Power BI Report Builder: An Introduction and explains how to Create A Matrix In Power BI Report Builder
🚀 Deployment, Security and Operations
- On the Power BI blog, Ikechukwu Edeagu (@MSPowerBI) announces Power BI Activity Logs: New Workspace Metadata for Excel Scenarios
- Gilbert Quevauvilliers (@GilbertQue) blogs about Scheduling the Power BI Premium Backup – Part 2
- Shabnam Watson (@ShbWatson) writes about Incremental Refresh for Power BI datasets based on a numeric column (Year): Working with Parquet/Delta files in Azure Synapse Analytics
🌐 General
- Adam Saxton (@GuyInACube) delves into Guy in a Cube answers the web’s most searched questions on Power BI