Learn how to try Power BI Desktop’s new Power Query Editor preview, explore Schema view, Diagram view, query folding and new transformations, and check known limitations before switching.

Power BI ModelSweep is an editable PBIP-based toolkit for model health, field usage, dependencies, best-practice checks and reviewable cleanup outputs.

Excelized helps turn messy data into clear dashboards and better decisions with Excel, Power BI, Power Query, Power Automate, practical training, templates, and free tools.

Connect Excel to the Open-Meteo API and build a refreshable seven-day European weather forecast with reusable Power Query M code, governance controls, KPI cards, and charts.

Connect Excel to the Open-Meteo API and build a refreshable seven-day European weather forecast with reusable Power Query M code, governance controls, KPI cards, and charts.

Dirty data does not announce itself. It arrives quietly as blank cells, "N/A" placeholders, stray zeros, or entirely empty columns that looked fine in the source system. Left untreated, these inconsistencies silently corrupt your totals, break your relationships, and cause scheduled refreshes to fail at the worst possible moment. This guide shows you how to stop patching issues one column at a time and build a small library of reusable M functions that handle every table inco

Learn how to use native queries in Power BI to write SQL directly against your data source. Step-by-step guide with M code, tips, and a practice file included.

A ready-to-use Excel currency converter with a 90-day FX history, dropdown filters, KPI cards, and two interactive charts. Free download included with step-by-step setup instructions.

Go beyond sales reports — connect Power BI to your IT, HR, finance, and admin systems using custom connectors. A practical guide to unlocking organisation-wide analytics.

SharePoint can be either your best “single source of truth”… or the reason your refreshes fail on Monday morning. This guide shows how to structure SharePoint properly (sites, libraries, lists), set permissions that scale, and connect everything cleanly to Excel and Power BI—with practical “do this / don’t do that” patterns. PRACTICE MATERIAL BELOW!👇 1) SharePoint basics that matter for BI people Sites, Libraries, Lists (the “3 boxes” model) Site = the container (security b

If you’ve ever wanted cleaner dashboards, faster “at-a-glance” reading, and less “wall of numbers” fatigue—Unicode symbols + hex colors are a surprisingly powerful combo. In this post you’ll learn practical, copy-paste-ready tricks for Excel, Power BI (DAX + conditional formatting), and Power Query. PRACTICE MATERIAL BELOW!👇 Why this matters (real-life use cases) Status columns that actually read well: ✅ OK, ⚠ Warning, ❌ Issue, ⏳ Pending KPI trend indicators: ▲ / ▼ / • witho

Jtzt Abonnie Overview When you connect Power Query / Power BI to a SharePoint site (or document library), there are (at least) two common M-functions you may see or use: SharePoint.Files(siteUrl as text, optional options as record) as table SharePoint.Contents(siteUrl as text, optional options as record) as table Although they sound similar, their behavior, performance, metadata returned, and navigation experience differ. Understanding their differences helps in building more

Hook: If your model “mysteriously” changes numbers, breaks relationships, or sorts months alphabetically—blame data types. What we’ll cover: where to define types (and why), the safest order of operations across the ETL chain, Power Query vs. Model vs. Table View, special cases (DirectQuery, currency, duration), and concrete, copy-paste examples. 1) Why data types matter (and where they live) Power Query (PQ): Data shaping stage. Types here affect folding, transformations

Hook: Hard-coded paths are silent project killers. Move a file, share a workbook, or publish a PBIX—and boom: refresh fails. Goal: In ~10 minutes you’ll set up robust, parameter-driven paths for Excel (Power Query) and Power BI (Desktop & Service), plus a tiny, reusable M pattern you can paste into any project. PRACTICE MATERIAL BELOW!👇 1) Why hard-coded paths fail When you embed "C:\Users\Alice\Project\data.csv" in a query, anyone whose files live elsewhere (e.g., D:\Work\

Goal: a fast, self-updating Power BI report that tracks earthquakes in the European–Mediterranean region (with a global table for comparison), highlights activity hotspots, and surfaces clean KPIs for decision-making. Scope: Earthquakes in the European-Mediterranean region with magnitude 4.5 or greater within the last 720 days or the last 2 years. Source: ETH Zürich - Swiss Seismological Service (HTML daily data): http://www.seismo.ethz.ch/en/earthquakes/europe/last90daysMa

Power Query is often seen as a tool for just loading and cleaning data — but it offers far more than the basics. Most users rely on a handful of transformations, while the UI hides powerful features that can make your workflow faster, cleaner, and easier to maintain. In this post, I’ll walk you through the best Power Query UI functions and hidden gems — no M code required. I repeat, no M-code, just UI!!! "Discover the Top 10 Power Query UI Gems: From automatic data type detec

Power BI’s Power Query (M language) allows creating custom functions and reusable query steps to simplify common tasks. Below are five versatile M-code solutions – a mix of data transformation helpers and analysis utilities – that you can copy into your Power BI queries with minimal adjustments. Each function includes the full M code, an explanation of its purpose, and an example use case in real-world projects. PRACTICE MATERIAL BELOW!👇 Explore the Top 5 essential M-Code fu

Want faster refreshes and snappier previews? Here’s a practical, no-nonsense guide to making Power Query load much quicker using only generic patterns and examples. PRACTICE MATERIAL BELOW!👇 Quick Wins Fold early, fold often: Filter and select columns as the first steps. Prune columns: Load only what you use. Reference, don’t duplicate: Reuse staged queries. Avoid row-by-row custom columns: Prefer joins, grouping, and native operations. Use buffering sparingly: Only when you

Have you ever received an email with a link to download a CSV or Excel file, and wished it could just go straight into your Excel sheet or Power BI dashboard? Good news: it can. With Power Query, you can connect directly to these file links—whether they’re public or require Microsoft login—and automatically load them into Excel or Power BI. This blog shows how to do it step by step. PRACTICE MATERIAL BELOW!👇 Why Use Power Query for Email-Based Downloadable Links? (M-code to

When you're transforming data in Power BI or Excel using Power Query, you're bound to run into errors—mismatched data types, division by text, nulls, you name it. But instead of manually inspecting row by row, why not automate error detection with a custom Power Query function? PRACTICE MATERIAL BELOW!👇 In this blog post, I’ll walk you through a clean method to catch and analyze all row-level errors using Power Query. This approach works great when importing or transforming