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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
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.