Power BI Weekly
Issue #256 - 30th April 2024
No announcements this week, so we'll jump straight into the highlighted articles. Firstly, Ben Gribaudo has written a quick tip if you're using Time Values from Dataflow to Power BI via DirectLake. Chris Webb has started an insightful new series, writing about Power BI Semantic Model Memory Errors, Part 1: Model Size. Elsewhere, Reid Havens has shown the value of baked-in documentation in the video Adding Integrated Bookmark Notes in a Power BI Report, and Sandeep Pawar has described the process of Exporting Power BI Reports And Sharing With Granular Access Control In Fabric.
Finally, my colleague Barry has gathered his thoughts (from his many years in the industry) to write a sequel to his popular Microsoft Fabric For Technology Leaders series, writing the more generic blog Data is a socio-technical endeavour. He discusses in depth about his opinion on the ingredients required to build a high-performance data team, covering topics like the importance of a Product Mindset, creating Multi-Disciplinary teams and incorporating DataOps principles and processes. I highly recommend taking a read through his thinking here.
🛠️ Data Prep
- Rick de Groot (@Rickmaurinus) explains how to Mimic a SWITCH function in Power Query using Record.FieldOrDefault and describes Creating a SWITCH Function with Conditions in Power Query M
- Joseph Yeates (@FthrsAnalytics) covers Split Column by Line Feed Special Character
- On the phData blog, Gavin Pedersen (@gavin_PD) explains How to Change a Snowflake Connection From Public to Private in Power BI Datasets
- Ben Gribaudo (@bgribaudo) blogs about Time Values from Dataflow to Power BI via DirectLake
🧩 Data Modeling
- On the Tabular Editor blog, Morten Lønskov announces Tabular Editor 3: April 2024 Release
- Chris Webb (@cwebb_bi) writes about Power BI Semantic Model Memory Errors, Part 1: Model Size
- Chandeep Chhabra (@chandeep2786) explains How to Create a Measures Table in Power BI
- On the SQLBI blog, Kurt Buhler (@kurtbuhler) covers Comparing cumulative values for events in different periods
📊 Report Authoring and Interactivity
- Chandeep Chhabra (@chandeep2786) describes Non-Sticky Slicer Trick in Power BI
- Bas Dohmen (@HowToPowerBI) talks about Top 3 Survey Visuals in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about New Button Slicer & Card in Microsoft Power BI Desktop
- Reid Havens (@HavensBI) describes Adding Integrated Bookmark Notes in a Power BI Report
- On the Learning Science YouTube channel, Learning Science explains How to create a Power BI report for a mobile phone - Just in few clicks | Mobile layout auto-create
🚀 Deployment, Security and Operations
- Sandeep Pawar (@PawarBI) describes Exporting Power BI Reports And Sharing With Granular Access Control In Fabric
🌐 General
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 275 - Power BI March 2024 Feature Summary
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) talks about Will Copilot in PowerBI Desktop ever be able to help you?