#powerquery — Public Fediverse posts

Split Data without any Formulas in Power Query Excel Part 90 :
Split data in Power Query by using the “Split Column” option—no formulas needed, just choose your delimiter or number of characters.
#PowerQuery #ExcelTips #DataCleaning #ExcelTutorial #SplitColumn #DataAnalytics #ExcelPowerQuery

Split Data without any Formulas in Power Query Excel Part 90 :
Split data in Power Query by using the “Split Column” option—no formulas needed, just choose your delimiter or number of characters.
#PowerQuery #ExcelTips #DataCleaning #ExcelTutorial #SplitColumn #DataAnalytics #ExcelPowerQuery

Mastering Data Modeling in Power BI – Full Course [ Zero To Hero ]

powerbi #datamodeling #powerbidatamodeling #modeling #powerquery #powerbitutorial Hey, Everyone Welcome back to our ... source

https://quadexcel.com/wp/mastering-data-modeling-in-power-bi-full-course-zero-to-hero/

Move or Reorder your columns using Power Query Excel Part 88:
Easily move or reorder your columns in Excel Power Query by dragging them to a new position in the query editor.
#exceltips #powerquery #datacleaning #exceltutorial #excelskills #dataanalysis

Move or Reorder your columns using Power Query Excel Part 88:
Easily move or reorder your columns in Excel Power Query by dragging them to a new position in the query editor.
#exceltips #powerquery #datacleaning #exceltutorial #excelskills #dataanalysis

Replace Values & Fill Columns in Excel Power Query For Data Cleaning:
In Excel Power Query, Replace Values lets you quickly fix or update specific data entries, while Fill Columns (Down or Up) fills missing cells using nearby values — both essential for smooth and complete datasets. #ExcelTips #PowerQuery #DataCleaning #ExcelTutorial #ExcelSkills #DataPrep

Replace Values & Fill Columns in Excel Power Query For Data Cleaning:
In Excel Power Query, Replace Values lets you quickly fix or update specific data entries, while Fill Columns (Down or Up) fills missing cells using nearby values — both essential for smooth and complete datasets. #ExcelTips #PowerQuery #DataCleaning #ExcelTutorial #ExcelSkills #DataPrep

Rename Columns ,Detect & Change Data Types in Excel Power Query Part 86:Rename Columns, Detect & Change Data Types in Excel Power Query help organize and clean your data by giving clear headers and ensuring correct data formats for accurate analysis. #ExcelTips #PowerQuery #DataCleaning #ExcelTutorial #DataTypes #ExcelSkills

Rename Columns ,Detect & Change Data Types in Excel Power Query Part 86:Rename Columns, Detect & Change Data Types in Excel Power Query help organize and clean your data by giving clear headers and ensuring correct data formats for accurate analysis. #ExcelTips #PowerQuery #DataCleaning #ExcelTutorial #DataTypes #ExcelSkills

Transpose ,Reverse Rows and Transform Data in Power Query Part 85:
Transpose flips rows into columns and columns into rows, Reverse Rows reorders data from bottom to top, and Transform Data opens Power Query Editor to clean, shape, and modify data before loading into Excel.
#PowerQuery #ExcelTips #DataTransformation #ExcelTutorial #LearnExcel #DataCleaning #ExcelPowerQuery

Transpose ,Reverse Rows and Transform Data in Power Query Part 85:
Transpose flips rows into columns and columns into rows, Reverse Rows reorders data from bottom to top, and Transform Data opens Power Query Editor to clean, shape, and modify data before loading into Excel.
#PowerQuery #ExcelTips #DataTransformation #ExcelTutorial #LearnExcel #DataCleaning #ExcelPowerQuery

Secret to no Pivot Tables By Using Power Query Part 84:
The Group By feature in Power Query summarizes data by grouping rows based on one or more columns and applying aggregate functions like sum, count, or average.
#PowerQuery #ExcelTips #GroupBy #DataCleaning #ExcelTutorial #PowerBI #DataTransformation #ExcelHacks

Secret to no Pivot Tables By Using Power Query Part 84:
The Group By feature in Power Query summarizes data by grouping rows based on one or more columns and applying aggregate functions like sum, count, or average.
#PowerQuery #ExcelTips #GroupBy #DataCleaning #ExcelTutorial #PowerBI #DataTransformation #ExcelHacks

Manage Parameters in Power Query Excel Part 83:
Manage Parameters in Power Query lets you create and edit reusable input values (like file paths, thresholds, or filters) to make queries dynamic and easier to update.
#powerquery #exceltips #dataautomation #ManageParameters #ExcelPowerTools #datacleaning #exceltutorial

Manage Parameters in Power Query Excel Part 83:
Manage Parameters in Power Query lets you create and edit reusable input values (like file paths, thresholds, or filters) to make queries dynamic and easier to update.
#powerquery #exceltips #dataautomation #ManageParameters #ExcelPowerTools #datacleaning #exceltutorial

Append Queries In Power Query Merge tables vertically Part 82:
Append Queries in Power Query combines data from two or more tables with the same columns into one unified table.
#PowerQuery #ExcelTips #DataCleaning #AppendQueries #ExcelTutorial #ExcelPowerQuery #DataAnalysis #ExcelSkills #LearnExcel #SpreadsheetTips

Append Queries In Power Query Merge tables vertically Part 82:
Append Queries in Power Query combines data from two or more tables with the same columns into one unified table.
#PowerQuery #ExcelTips #DataCleaning #AppendQueries #ExcelTutorial #ExcelPowerQuery #DataAnalysis #ExcelSkills #LearnExcel #SpreadsheetTips

Merge Tables without Formulas Part 81:
Combine data from multiple tables into one using Power Query’s Merge Queries, matching columns to bring everything together automatically.
#ExcelTips #PowerQuery #ExcelMerge #DataCleaning #ExcelTutorial #ExcelForBeginners #LearnExcel #ExcelMagic #MergeQueries #ExcelSkills

Merge Tables without Formulas Part 81:
Combine data from multiple tables into one using Power Query’s Merge Queries, matching columns to bring everything together automatically.
#ExcelTips #PowerQuery #ExcelMerge #DataCleaning #ExcelTutorial #ExcelForBeginners #LearnExcel #ExcelMagic #MergeQueries #ExcelSkills

Transform Data in Power Query Part 79 :
Transform Data in Power Query lets you clean, shape, and prepare your data before loading it into Excel for analysis.
#PowerQuery #ExcelTips #DataCleaning #TransformData #ExcelTutorial #DataPreparation #ExcelPowerQuery #ExcelMastery

Transform Data in Power Query Part 79 :
Transform Data in Power Query lets you clean, shape, and prepare your data before loading it into Excel for analysis.
#PowerQuery #ExcelTips #DataCleaning #TransformData #ExcelTutorial #DataPreparation #ExcelPowerQuery #ExcelMastery

Group By Option Power Query Part 78:
Group By in Power Query aggregates rows based on one or more columns to summarize data (e.g., sum, count, average).
#PowerQuery #ExcelTips #DataCleaning #GroupBy #ExcelTutorial #DataTransformation #PowerBI #ExcelHacks

Group By Option Power Query Part 78:
Group By in Power Query aggregates rows based on one or more columns to summarize data (e.g., sum, count, average).
#PowerQuery #ExcelTips #DataCleaning #GroupBy #ExcelTutorial #DataTransformation #PowerBI #ExcelHacks

Group By Option Power Query Part 77:
Group By in Power Query aggregates rows based on one or more columns to summarize data (e.g., sum, count, average).
#PowerQuery #ExcelTips #DataCleaning #GroupBy #ExcelTutorial #DataTransformation #PowerBI #ExcelHacks

Group By Option Power Query Part 77:
Group By in Power Query aggregates rows based on one or more columns to summarize data (e.g., sum, count, average).
#PowerQuery #ExcelTips #DataCleaning #GroupBy #ExcelTutorial #DataTransformation #PowerBI #ExcelHacks

PowerQueryを自在に操る：Excelブックのクエリ定義を一括エクスポート＆インポートするPowerShellスクリプト
https://qiita.com/madilloar/items/067ea1065c6d56e9ab2d?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PowerShell #PowerQuery

Delete Unwanted Columns in Excel Power Query Part 74:
Quickly clean your data by deleting unnecessary columns in Excel Power Query for a smoother workflow. #ExcelTips #PowerQuery #DataCleaning #ExcelHacks #productivityhacks

Delete Unwanted Columns in Excel Power Query Part 74:
Quickly clean your data by deleting unnecessary columns in Excel Power Query for a smoother workflow. #ExcelTips #PowerQuery #DataCleaning #ExcelHacks #productivityhacks

「空列だらけの巨大テーブル、どう読む？」— Python In Excel or PowerQueryで“意味ある列”だけ抽出するには
https://qiita.com/madilloar/items/8d24d19a581ae33524f7?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Python #Excel #データ分析 #PowerQuery

Wie nervig das ist, wenn man in MS #PowerQuery viel im Erweiterten Editor arbeitet und sich dessen Fenster bei jedem Öffnen (gefühlt 100x am Tag) immer wieder in seiner kleinen Default-Größe öffnet!!! Arrrgggrrr! 🤬😤 ICH BRAUCH’ DEN IN GROẞ, liebes #Microsoft!! Kann er sich nicht wenigstens seine letzte Fenstergröße merken!? Ich hab das Gefühl, ich stecke in den 1990ern fest!! #DataScience #ETL #PowerBI #Excel

Wie nervig das ist, wenn man in MS #PowerQuery viel im Erweiterten Editor arbeitet und sich dessen Fenster bei jedem Öffnen (gefühlt 100x am Tag) immer wieder in seiner kleinen Default-Größe öffnet!!! Arrrgggrrr! 🤬😤 ICH BRAUCH’ DEN IN GROẞ, liebes #Microsoft!! Kann er sich nicht wenigstens seine letzte Fenstergröße merken!? Ich hab das Gefühl, ich stecke in den 1990ern fest!! #DataScience #ETL #PowerBI #Excel

Two new #PowerBI / #PowerQuery books

https://blog.crossjoin.co.uk/2025/04/27/two-new-power-bi-power-query-books/

Two new #PowerBI / #PowerQuery books

https://blog.crossjoin.co.uk/2025/04/27/two-new-power-bi-power-query-books/

I do things in #Excel #PowerQuery a lot. One of the things I need to do involve a pivot and then needing to rearrange a column, if it exists, to the second position. This is all dynamic and I don't have a fixed set of known columns.

Finally found a good answer after a year:

https://blog.dhampir.no/content/moving-columns-in-powerquery-without-naming-every-column

Remove Empty Rows with Macro #ExcelAutomation #VBA #ExcelTips #PowerQuery #ExcelMacros #AutomateExcel #DataAutomation #ExcelHacks #OfficeAutomation #ExcelProductivity #ExcelScripting #ExcelVBA #ExcelTimeSaver #ExcelFilter #ExcelMagic #DynamicFilter #datafilteringinexcel #MacroButton #ExcelDashboard #ExcelButtonHack

Automate tasks in excel by coding #ExcelAutomation #VBA #ExcelTips #PowerQuery #ExcelMacros #AutomateExcel #DataAutomation #ExcelHacks #OfficeAutomation #ExcelProductivity #ExcelScripting #ExcelVBA #ExcelTimeSaver
#ExcelFilter #ExcelMagic #DynamicFilter #datafilteringinexcel #MacroButton #ExcelVBA #ExcelDashboard #ExcelButtonHack #ExcelScripting #ExcelEfficiency #datascience #dataextractor #techtutorial #Coding #AnonymousFunction

📊 ¿Tienes varias tablas con información que necesitas juntar? ¡No más copiar y pegar manualmente!
Te enseñaré cómo usar Power Query para unir varias tablas a través de un campo en común, de forma fácil, rápida y sin errores.

🔍 En esta serie de videos verás: ✅ Cómo identificar los campos clave para unir tablas. ✅ Tipo de combinaciones puedes hacer. ✅ Cómo automatizar este proceso cada vez que actualices tus datos.
#Excel #PowerQuery #UnirTablas #Productividad #InteligenciaDeNegocios
 

📊 ¿Listo para dar el siguiente paso con Power Query? 🚀
En esta segunda parte, veremos cómo empezar a usar esta increíble herramienta y por qué te ayudará a trabajar más rápido y mejor en Excel.
Te permite: ✅ Importar datos de diferentes fuentes. ✅ Organizar información de forma sencilla. ✅ crear tareas repetitivas.
🔍 Es solo el comienzo, pero ya estás en el camino correcto.
🔽 Sigue la serie y aprende paso a paso cómo dominar Power Query. ✨
#Excel #PowerQuery #Datos #Productividad
 

📊 ¿Manejas datos en Excel? Entonces necesitas conocer Power Query. 🚀
Lo que hoy haces en horas, con Power Query lo harás en minutos. ⏳✨
🔍 ¿No sabes qué es Power Query? Es la herramienta que cambiará tu forma de trabajar con Excel para siempre.
🚀 Este es solo el comienzo. Prepárate para nuestra serie de videos donde aprenderás a dominar cada uno de sus comandos y a transformar tus datos como un experto.
🔽 ¡Síguenos y aprende a dominar Power Query! #Excel #PowerQuery #Productividad

Column from example in Power Query #excel #powerquery #exceltricks #dataanalytics
https://youtube.com/shorts/rVhSV0ZGRuQ

Fix Data Type in Excel by using Power Query without any formulas #excel #datascience #powerquery

Fix Data Type in Excel by using Power Query without any formulas #excel #datascience #powerquery

How to make sure that you're getting the updated file in #PowerQuery, without the browser's or server's caching conflict: https://deuts.org/p/powerquery-bypass-cache/

Reading Delta metadata in #PowerQuery

https://blog.crossjoin.co.uk/2025/02/16/reading-delta-metadata-in-power-query/

Reading Delta metadata in #PowerQuery

https://blog.crossjoin.co.uk/2025/02/16/reading-delta-metadata-in-power-query/

Improve #PowerQuery performance on CSV files containing Date columns

https://blog.crossjoin.co.uk/2025/02/09/improve-power-query-performance-on-csv-files-containing-date-columns/

I'm looking for #emacs packages related to all things Power BI, but not finding much -- just this: https://fpvmorais.com/post/emacs-major-modes-for-power-bi/ Does anyone know of anything else?

#powerbi #dax #powerquery #m

💰 Ever tried processing payments on a holiday? Yeah, banks just laugh at you. 🤡 I wrote a Power Query function that skips weekends and holidays to get the next banking day—because money waits for no one (except financial institutions).

Check it out: https://deuts.org/p/power-query-next-banking-day/

#PowerQuery
#Mlanguage
#FinancialTech
#DataScience

Is it just me? I find so much insight from running docker stats regularly via cron, logging them, and data modeling and analyzing via #PowerQuery and #PowerPivot #DAX compared to what I have with the #Prometheus, #Grafana, CAdvisor, and Node-Exporter. The latter further consumes system resources.