Power BI Weekly #291 - 14th January 2025
Power BI Weekly Newsletter Issue #291
powered by endjin
Welcome to the 291st edition of Power BI Weekly! No official Power BI blogs yet, so let's dive into the community articles. To start, Eugene Meidinger has written a thought-provoking piece on How Power BI Dogma Leads to a Lack of Understanding, highlighting that "best practices" are just a set of guiding principles (and how sometimes it's OK (or even necessary) to break said practices), and how being overly dogmatic can negatively influence your and others' learning. Very interesting read. Elsewhere this week, Andy Forrester has described how to Import Microsoft Project Data into Power BI Using Python (avoiding manual importing of Excel files), Ioannis Doganos has provided an end-to-end example about How I automated a monthly PowerPoint presentation using Power BI, and Lasse Malo has told us to Forget The Publish Button In Power BI Desktop Ever Existed, walking through the OneDrive/SharePoint integration for pbix files which allows for automatic syncing of your report into the Power BI Service (a feature we use heavily here at endjin!).
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
- Laura Graham-Brown (@Laura_GB) writes about Power Query – Creating New Parameter Made Easier and Power Query – Fixing Missing Columns Dynamically
- On the SQL Server Central blog, John Kerski (@JKerski) describes Comparing Groups for Similarities in Power Query – Using Cosine Similarity
- Chandeep Chhabra (@chandeep2786) presents Getting Started with {M} in Power Query | Live Event
- Sunil Mathew (@_sunil_mathew_) describes how to Dynamically Switch Data source (Excel to SQL) with Power Query Parameters | Power BI Tutorials
- Shivanshu Bisht describes how to Combine Multiple Google Sheets in Power Query
- Andy Forrester describes Importing Microsoft Project Data into Power BI Using Python
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the Power BI community blog, Tharun Kumar Ravikrindhi discusses SVG based Power BI semantic model columns and measures are great but there is a problem
- ,, Parul Sagar (@parulsagar) writes about Statistical Insights Using CHISQ.DIST in Power BI DAX
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Business Intelligist blog, Nikil Prabhakar covers Unlocking the Power of Field Parameters in Power BI
- On the Power BI community blog, Anmol Malviya explains how to Manage Large Datasets More Efficiently with Power BI’s New Data Limit Feature
- Reid Havens (@HavensBI) talks about Waterfall Charts with Categories (and Considerations...)
- Bas Dohmen (@HowToPowerBI) explains how to Build this unique chart with me | Power BI
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) explains How to add more than two data labels to Columns, Bars, Lines, and Ribbon charts in Power BI?
- Audrée Pellerin (@lecfomasque) covers Intelligence artificielle dans Power BI : Visuels [French]
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Microsoft Fabric Café YouTube channel, Reid Havens (@HavensBI) describes how to Avoid Data Silos | Best Practices for Implementing Shared Semantic Models
- Chris Webb (@cwebb_bi) writes about Changing The Source Lakehouse Of Power BI Direct Lake Models In Deployment Pipelines
- Mimoune Djouallah (@mim_djo) writes about Fabric for Small Enterprises
- Lasse Malo writes Forget The Publish Button In Power BI Desktop Ever Existed
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Eugene Meidinger (@sqlgene) discusses How Power BI Dogma Leads to a Lack of Understanding
- On the RADACAD blog, Reza Rad (@RADACAD_COM) talks about Where to Start Microsoft Fabric as a Power BI Developer
- Ioannis Doganos describes How I automated a monthly PowerPoint presentation using Power BI
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 #498 - 12th January 2025
Sunday, January 12, 2025
Festive Tech Calendar 2024 recap, GitHub Copilot Bootcamp, and Dev Containers FTW!
☁️ Azure Weekly #497 - 15th December 2024
Thursday, December 19, 2024
Phi 4, Azure Communication Services Email 101 & lots of DevOps
Power BI Weekly #285 - 19th November 2024
Tuesday, November 19, 2024
Power BI Weekly Newsletter Issue #285 powered by endjin Welcome to the 285th edition of Power BI Weekly! Quite a short one this week. A couple of people have written about the new Path Layer feature
☁️Azure Weekly #493 - 17th November 2024
Sunday, November 17, 2024
.NET 9.0 GA, KubeCon North America 2024
☁️ Azure Weekly #491 - 3rd November 2024
Sunday, November 3, 2024
Responsible AI, Compute-Intensive Workloads & Flatcar incubating at CNCF
You Might Also Like
Import AI 399: 1,000 samples to make a reasoning model; DeepSeek proliferation; Apple's self-driving car simulator
Friday, February 14, 2025
What came before the golem? ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Defining Your Paranoia Level: Navigating Change Without the Overkill
Friday, February 14, 2025
We've all been there: trying to learn something new, only to find our old habits holding us back. We discussed today how our gut feelings about solving problems can sometimes be our own worst enemy
5 ways AI can help with taxes 🪄
Friday, February 14, 2025
Remotely control an iPhone; 💸 50+ early Presidents' Day deals -- ZDNET ZDNET Tech Today - US February 10, 2025 5 ways AI can help you with your taxes (and what not to use it for) 5 ways AI can help
Recurring Automations + Secret Updates
Friday, February 14, 2025
Smarter automations, better templates, and hidden updates to explore 👀 ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
The First Provable AI-Proof Game: Introducing Butterfly Wings 4
Friday, February 14, 2025
Top Tech Content sent at Noon! Boost Your Article on HackerNoon for $159.99! Read this email in your browser How are you, @newsletterest1? undefined The Market Today #01 Instagram (Meta) 714.52 -0.32%
GCP Newsletter #437
Friday, February 14, 2025
Welcome to issue #437 February 10th, 2025 News BigQuery Cloud Marketplace Official Blog Partners BigQuery datasets now available on Google Cloud Marketplace - Google Cloud Marketplace now offers
Charted | The 1%'s Share of U.S. Wealth Over Time (1989-2024) 💰
Friday, February 14, 2025
Discover how the share of US wealth held by the top 1% has evolved from 1989 to 2024 in this infographic. View Online | Subscribe | Download Our App Download our app to see thousands of new charts from
The Great Social Media Diaspora & Tapestry is here
Friday, February 14, 2025
Apple introduces new app called 'Apple Invites', The Iconfactory launches Tapestry, beyond the traditional portfolio, and more in this week's issue of Creativerly. Creativerly The Great
Daily Coding Problem: Problem #1689 [Medium]
Friday, February 14, 2025
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. Given a linked list, sort it in O(n log n) time and constant space. For example,
📧 Stop Conflating CQRS and MediatR
Friday, February 14, 2025
Stop Conflating CQRS and MediatR Read on: my website / Read time: 4 minutes The .NET Weekly is brought to you by: Step right up to the Generative AI Use Cases Repository! See how MongoDB powers your