---
title: "#powerquery articles | Hashnode"
description: "PowerQuery is Microsoft's ETL language \"M\" used in Excel, Power BI, Azure Data Flow. Read the latest #powerquery articles and tutorials on Hashnode."
url: "https://hashnode.com/tag/powerquery"
---

Tag

# #powerquery

33 posts · 10 followers

[Aniket Kumar Mishra](https://hashnode.com/@armaandata) · [Nov 12](https://hashnode.com/posts/combine-many-excel-files-into-one-table-with-power-query/6af5b9c7b323451bbe3dcfea)

### [Combine many Excel files into one table with Power Query](https://armaandata.hashnode.dev/combine-many-excel-files-into-one-table-with-power-query?utm_source=hashnode&utm_medium=feed)

Step by step: combine a folder of Excel or CSV files into one table with Power Query, and refresh it every month.

2 min read · [armaandata.hashnode.dev](https://armaandata.hashnode.dev/combine-many-excel-files-into-one-table-with-power-query?utm_source=hashnode&utm_medium=feed)

[AdminPackStudio](https://hashnode.com/@adminpackstudio) · [Oct 7](https://hashnode.com/posts/excel-csv-ops-for-it-admins-cleaning-intune-device-exports-without-breaking-your-upns-power-query-basics-9-pitfalls/6ac650d100d87df0c794a6c8)

### [Excel & CSV ops for IT admins: cleaning Intune device exports without breaking your UPNs (Power Query basics + 9 pitfalls)](https://adminpackstudio.hashnode.dev/excel-csv-ops-for-it-admins-cleaning-intune-device-exports-without-breaking-your-upns-power-query-basics-9-pitfalls?utm_source=hashnode&utm_medium=feed)

Clean Intune device CSV exports in Excel without breaking UPNs: safe import, dedupe stale records, and a refreshable Power Query, plus 9 pitfalls.

8 min read · [adminpackstudio.hashnode.dev](https://adminpackstudio.hashnode.dev/excel-csv-ops-for-it-admins-cleaning-intune-device-exports-without-breaking-your-upns-power-query-basics-9-pitfalls?utm_source=hashnode&utm_medium=feed)

[Brian King](https://hashnode.com/@SoloDevNZ) · [Jul 8](https://hashnode.com/posts/running-hermes-agent-in-yolo-mode/6a4da1c89ce6662e6f3794d1)

### [Running Hermes Agent in YOLO Mode.](https://solodev.app/running-hermes-agent-in-yolo-mode?utm_source=hashnode&utm_medium=feed)

Or: Going to Bed while the AI Continues to Crunch.

4 min read · [solodev.app](https://solodev.app/running-hermes-agent-in-yolo-mode?utm_source=hashnode&utm_medium=feed)

[Yash Vardhan Vashistha](https://hashnode.com/@yvv) · [Jan 26](https://hashnode.com/posts/extraction-transformation-and-load-in-power-bi/6977e8a49d3f11d13f6a0ecc)

### [Extraction, Transformation & Load in Power BI](https://power-bi-series.hashnode.dev/extraction-transformation-and-load-in-power-bi?utm_source=hashnode&utm_medium=feed)

Learn the essentials of data extraction, transformation, and loading (ETL) in Power BI using Power Query for effective report building

8 min read · [power-bi-series.hashnode.dev](https://power-bi-series.hashnode.dev/extraction-transformation-and-load-in-power-bi?utm_source=hashnode&utm_medium=feed)

[Norman Reynaldo Sabillon Castro](https://hashnode.com/@NorSab) · [Sep 11, 2025](https://hashnode.com/posts/capitulo-4-limpieza-de-datos-traduciendo-tus-primeros-pasos-de-power-query-a-pandas/68c2e1b5a15a7baa1dcc98c7)

### [Capítulo 4: Limpieza de Datos - Traduciendo tus Primeros Pasos de Power Query a Pandas](https://normansabillon.hashnode.dev/capitulo-4-limpieza-de-datos-traduciendo-tus-primeros-pasos-de-power-query-a-pandas?utm_source=hashnode&utm_medium=feed)

Aprende a traducir tus habilidades de limpieza de datos de Power Query a Python con Pandas. Una guía paso a paso para analistas de BI, usando datos reales.

9 min read · [normansabillon.hashnode.dev](https://normansabillon.hashnode.dev/capitulo-4-limpieza-de-datos-traduciendo-tus-primeros-pasos-de-power-query-a-pandas?utm_source=hashnode&utm_medium=feed)

[Norman Reynaldo Sabillon Castro](https://hashnode.com/@NorSab) · [Aug 26, 2025](https://hashnode.com/posts/el-primer-paso-conectando-a-datos-en-power-query-vs-python-con-pandas/68add6a9bfe40f9272604e53)

### [El Primer Paso - Conectando a Datos en Power Query vs. Python con Pandas](https://normansabillon.hashnode.dev/el-primer-paso-conectando-a-datos-en-power-query-vs-python-con-pandas?utm_source=hashnode&utm_medium=feed)

Aprende a conectar a un origen de datos en Power Query y su equivalente en Python con Pandas. La guía perfecta para profesionales de BI que dan el salto ML

9 min read · [normansabillon.hashnode.dev](https://normansabillon.hashnode.dev/el-primer-paso-conectando-a-datos-en-power-query-vs-python-con-pandas?utm_source=hashnode&utm_medium=feed)

[Tanmay Sharma](https://hashnode.com/@tanmay27) · [Aug 24, 2025](https://hashnode.com/posts/building-a-youtube-content-intelligence-dashboard-sql-python-power-bi/68ab422443f77d8d8a895565)

### [🚀 Building a YouTube Content Intelligence Dashboard (SQL + Python + Power BI)](https://youtube-is-not-just-entertainment.hashnode.dev/building-a-youtube-content-intelligence-dashboard-sql-python-power-bi?utm_source=hashnode&utm_medium=feed)

YouTube is not just entertainment — it’s data gold. Every like, view, and comment tells a story. In this project, I built a YouTube Content Intelligence Platform using SQL, Python, and Power BI to uncover what drives engagement, subscriber growth, an...

2 min read · [youtube-is-not-just-entertainment.hashnode.dev](https://youtube-is-not-just-entertainment.hashnode.dev/building-a-youtube-content-intelligence-dashboard-sql-python-power-bi?utm_source=hashnode&utm_medium=feed)

[Bhargavi Adepu](https://hashnode.com/@bhargaviadepu) · [Jul 23, 2025](https://hashnode.com/posts/power-query-deep-dive-combining-grouping-and-advanced-transformations/6880af45da8557da5ba2911a)

### [“Power Query Deep Dive: Combining, Grouping & Advanced Transformations”](https://thefabricinsider.hashnode.dev/power-query-deep-dive-combining-grouping-and-advanced-transformations?utm_source=hashnode&utm_medium=feed)

Master advanced Power Query techniques in Power BI—learn how to merge, append, group, create parameters, handle errors, and more to clean and transform your

8 min read · [thefabricinsider.hashnode.dev](https://thefabricinsider.hashnode.dev/power-query-deep-dive-combining-grouping-and-advanced-transformations?utm_source=hashnode&utm_medium=feed)

[Bhargavi Adepu](https://hashnode.com/@bhargaviadepu) · [Jul 16, 2025](https://hashnode.com/posts/thefabricinsiderhashnodedevpower-query-data-cleaning-power-bi/68774849d488e1f346f7d712)

### [How to Clean and Transform Data in Power BI Using Power Query](https://thefabricinsider.hashnode.dev/thefabricinsiderhashnodedevpower-query-data-cleaning-power-bi?utm_source=hashnode&utm_medium=feed)

Learn how to clean and transform your data using Power Query in Power BI. This guide covers step-by-step transformations, including removing columns, renami

4 min read · [thefabricinsider.hashnode.dev](https://thefabricinsider.hashnode.dev/thefabricinsiderhashnodedevpower-query-data-cleaning-power-bi?utm_source=hashnode&utm_medium=feed)

[Jogleen Calipon](https://hashnode.com/@Jworkz) · [May 7, 2025](https://hashnode.com/posts/enhanced-sales-insights-with-a-dashboard-built-on-power-pivot-and-dax/681b0f620871568a9f76c64d)

### [Enhanced Sales Insights with a Dashboard Built on Power Pivot and DAX](https://excel-analysis.hashnode.dev/enhanced-sales-insights-with-a-dashboard-built-on-power-pivot-and-dax?utm_source=hashnode&utm_medium=feed)

Discover how to enhance sales insights using Power Pivot and DAX for effective data modeling, dashboard creation, and KPI analysis

7 min read · [excel-analysis.hashnode.dev](https://excel-analysis.hashnode.dev/enhanced-sales-insights-with-a-dashboard-built-on-power-pivot-and-dax?utm_source=hashnode&utm_medium=feed)
