Power BI Weekly
Issue #237 - 12th December 2023
No official blogs this week, so let's get straight to the week's highlighted articles. We'll start with Kurt Buhler who's, as ever, written a brilliant and thorough blog about things to consider when you Gather Requirements for Semantic Models. Patrick Leblanc has described how you can Boost your productivity with DAX Query View in Power BI Desktop (I love this feature - such a quick feedback loop when creating measures). Then Phil Seamark has returned with a couple of blogs around Semantic Link, describing how to Visualize a Power BI Refresh using the tool, and how we can use it in combination with a Fabric Notebook to monitor Power BI semantic models.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) covers Getting Different Versions Of Data With Value.Versions In Power Query
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains How to Extract Dates From Text Strings in Power Query (Excel / Power BI) Different Incorrect Format and describes How to Append Data from Many Excel Files into Microsoft Power BI (Power Query)
- Kim Leblanc (@lecfomasque) covers Maitrisez le code M dans Power Query avec ces 5 étapes [French]
- Sam McKay (@_EnterpriseDNA) describes Data Engineering w/ Dataflows
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Preparing a data model for Sankey Charts in Power BI
- Chandeep Chhabra (@chandeep2786) explains How to Calculate Moving Averages in Power BI - The Ultimate Guide
- Patrick Leblanc (@GuyInACube) discusses Boost your productivity with DAX Query View in Power BI Desktop
- Soheil Bakhshi (@biinsightnz) writes about Quick Tips: Find Power BI Desktop Local Port Number with Model Explorer
- Bernat Agulló Roselló (@AgulloBernat) discusses Building my first near real time model in Power BI
- Kurt Buhler (@kurtbuhler) describes how to Gather Requirements for Semantic Models
📊 Report Authoring and Interactivity
- Bas Dohmen (@HowToPowerBI) talks about Target Loading Effect on the New Card Visual in Power BI
- Reid Havens (@HavensBI) talks about New Visualization Formatting & Data Label Updates (with Miguel Myers)
- On the Learning Science YouTube channel, Learning Science explains How to describe data insights for Power BI visuals using AI?
- On the Power BI community blog, Muhammad Hasnain (@hasnain2587) writes about Dynamic titles in Power BI
🚀 Deployment, Security and Operations
- Phil Seamark (@PhilSeamark) explains how to Visualize Power BI Refresh using Semantic-link and describes how to Use Fabric Notebook to monitor Power BI semantic models
- Sandeep Pawar (@PawarBI) covers Refreshing Individual Tables and Partitions With Semantic Link