Azure Weekly - Power BI Weekly #256 - 1st May 2024
Power BI Weekly Newsletter Issue #256
powered by endjin
Welcome to the 256th edition of Power BI Weekly! 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.
If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.
Interested in Azure? Sign up to our sibling newsletter Azure Weekly to receive all the week's Azure news.
@edfreeman_ | @endjin
powerbiweekly.info | endjin.com
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Sandeep Pawar (@PawarBI) describes Exporting Power BI Reports And Sharing With Granular Access Control In Fabric
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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?
Useful Links
- Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
- Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
- M language reference - Official Power Query M Reference
- PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
- DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
- DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
- Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
- Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
- Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
- Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
- Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
- Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
Tweet | Forward | Preferences | Unsubscribe
Older messages
☁️ Azure Weekly #464 - 28th April 2024
Sunday, April 28, 2024
Azure Weekly Newsletter Issue #464 powered by endjin Welcome to issue 464 of the Azure Weekly Newsletter. In AI we have a good mix of high-level and deep-dive technical articles. Next-Gen Customer
Power BI Weekly #253 - 9th April 2024
Tuesday, April 9, 2024
Power BI Weekly Newsletter Issue #253 powered by endjin Welcome to the 253rd edition of Power BI Weekly. A couple of announcements this week. One of them has probably made itself apparent to those of
Power BI Weekly #252 - 2nd April 2024
Tuesday, April 2, 2024
Power BI Weekly Newsletter Issue #252 powered by endjin Welcome to the 252nd edition of Power BI Weekly! As the dust settles on SQLBits and FabCon, we can now reflect on the vast swathe of new Fabric
Power BI Weekly #251 - 26th March 2024
Tuesday, March 26, 2024
Power BI Weekly Newsletter Issue #251 powered by endjin Welcome to the 251st edition of Power BI Weekly. Move aside SQLBits, it's FabCon week this week, and there have already been some huge
Power BI Weekly #250 - 20th March 2024
Wednesday, March 20, 2024
Power BI Weekly Newsletter Issue #250 powered by endjin Welcome to the 250th edition of Power BI Weekly! SQLBits is upon us - I hope a good number of you have been fortunate enough to attend this year.
You Might Also Like
This Week's Daily Tip Roundup
Sunday, July 7, 2024
Missed some of this week's tips? No problem. We've compiled all of them here in one convenient place for you to enjoy. Happy learning! iPhoneLife Logo View In Browser Your Tip of the Day is
Laravel v11.14, Auth Screens for Your Laravel Apps, and more! - №520
Sunday, July 7, 2024
Your Laravel week in review ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Apple Goes Small and Super Multimodal
Sunday, July 7, 2024
Plus a lot of new models being released and quite an active week for AI VCs. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Kotlin Weekly #414
Sunday, July 7, 2024
ISSUE #414 7th of July 2024 Articles From Hilt to Koin using Koin Annotations This article explores Hilt and Koin, comparing both frameworks, and going through a detailed process for migrating from
Papers, Please/Will We Ever Get Fusion Power/Magic Color Picker
Sunday, July 7, 2024
Recomendo - issue #418 ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Weekend Reading — Gesturing wildly and in every direction
Saturday, July 6, 2024
This week we kick start the Slow Software Movement, CTRL+F the Spice Rack, walk over the kitchen table, slop the book, hide behind a tree, skip leg day, and hide under the weighted blanket. 😎 Labnotes
📳 Why Your Older iPhone Won't Get Apple Intelligence — The Perfect Gaming Controller
Saturday, July 6, 2024
Also: Apple TV+ Is Missing These Essential Features, and More! How-To Geek Logo July 6, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your
Mind The Pregap 💿
Saturday, July 6, 2024
The tale of the pregap, a weird quirk of the compact disc era. Here's a version for your browser. Hunting for the end of the long tail • July 06, 2024 Today in Tedium: Having gotten through a
Daily Coding Problem: Problem #1488 [Hard]
Saturday, July 6, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Airbnb. We're given a hashmap associating each courseId key with a list of courseIds
Ranked | The World's Most Endangered Animals 🦍
Saturday, July 6, 2024
We look at the 10 most endangered animals on the planet, showing estimated numbers left of each species. View Online | Subscribe Voronoi: The App Where Data Tells the Story FEATURED STORY Ranked: The