Microsoft Power Query@MSPowerQuery

Microsoft's premier Data Preparation technology and ETL tool used by several millions of users in desktop and online environments.

 Redmond, Washington
Based in Canada
powerquery.com
Joined September 2020
Implement Native Query support in your #PowerQuery Custom Connectors powerquery.microsoft.com/en-…
2
11
38
6,339
The #PowerQuerySDK for Visual Studio Code is now available in Windows ARM. Check it out today and start developing your own data connector for #PowerBI aka.ms/PowerQuerySDK
6
26
What are your thoughts on the reference feature? Do you use it often or do you prefer to duplicate your queries? #TransformTuesday #PowerQuery docs.microsoft.com/power-que…
Reference button in the right click contextual menu inside the Queries Pane

ALT Reference button in the right click contextual menu inside the Queries Pane

17
14
60
For today's #TransformTuesday we are making an exception. This time we are not showcasing a specific transform, but rather a feature that allows you to set transforms. What are your thoughts on the Diagram view in #PowerQuery? docs.microsoft.com/power-que…
The Power Query Online editor showing the Diagram view enabled and the Data Preview at the bottom

ALT The Power Query Online editor showing the Diagram view enabled and the Data Preview at the bottom

2
13
63
A new transform has arrived! Check out our latest blog post where @cwebb_bi showcases the new Rank transform available now in #PowerQuery online. Tell us what you think about it! powerquery.microsoft.com/en-…
4
20
95
Replying to @asmith83
Nope! We are not kidding. What about just extracting exactly the data that you need from the webpage by giving #PowerQuery some examples? :) This is available in @MSPowerBI --> docs.microsoft.com/power-que…
2
7
43
It's still #TransformTuesday ! and this week we focus on the updated article for error handling in #PowerQuery with the new catch keyword docs.microsoft.com/power-que…
Custom column dialog showing a formula where the try catch syntax is being use for error handling

ALT Custom column dialog showing a formula where the try catch syntax is being use for error handling

1
12
50
Have you ever tried the Cluster values feature in #PowerQuery? Cluster values automatically create groups with similar values using a fuzzy matching algorithm, and then maps each column's value to the best-matched group #TransformTuesday docs.microsoft.com/power-que…
Cluster values entry point in the Power Query ribbon inside of the Add column tab

ALT Cluster values entry point in the Power Query ribbon inside of the Add column tab

Cluster values dialog where the column 'Person' has been selected and the new column name has been set to 'Cluster'

ALT Cluster values dialog where the column 'Person' has been selected and the new column name has been set to 'Cluster'

The result of the Cluster values operation over the Person column that yields a new Cluster column

ALT The result of the Cluster values operation over the Person column that yields a new Cluster column

3
11
42
It’s back! For this week’s #TransformTuesday our transform or feature that helps us trigger some really cool transforms is the Data Profiling Tools. How often do you use these and what would you like to see next for them? #PowerQuery docs.microsoft.com/power-que…
Data quality and column distribution tools in the Power Query editor showcasing a suggested transforms card with common transforms like Keep Duplicates, Keep Errors and others in the Power Query experience found in Power BI Desktop

ALT Data quality and column distribution tools in the Power Query editor showcasing a suggested transforms card with common transforms like Keep Duplicates, Keep Errors and others in the Power Query experience found in Power BI Desktop

2
9
39
New #PowerQuery M Language keyword: catch - a new way to help you catch errors and implement your custom logic based on those errors. Article written by @bgribaudo powerquery.microsoft.com/en-…
Power Query Custom Column dialog showcasing a formula using the catch keyword in a try catch statement

ALT Power Query Custom Column dialog showcasing a formula using the catch keyword in a try catch statement

1
36
102
What are your thoughts on the Schema view available in #PowerQuery in Excel for Mac and the #PowerQuery Online experience? #TransformTuesday docs.microsoft.com/power-que…
2
5
20
We recently added the Percentile operation to the Group by feature. What other operation would you like to see being added to this experience in #PowerQuery and why? #TransformTuesday docs.microsoft.com/power-que…
The Power Query Group by dialog

ALT The Power Query Group by dialog

3
9
42
There's a new #PowerQuery transform in town 😎 Read more about the Percentile transform on the latest article from our blog written by @cwebb_bi powerquery.microsoft.com/en-…
The Group by dialog in Power Query online showcasing the new Percentile operation

ALT The Group by dialog in Power Query online showcasing the new Percentile operation

1
31
91
Did you know that you can just drag-and-drop files into the #PowerQuery canvas to start your query? We recently added a new feature called ‘Upload a file’ that you need to try out #TransformTuesday Learn more from docs.microsoft.com/power-que…
Upload file watermark after trying to drag and drop a file into the Power Query canvas

ALT Upload file watermark after trying to drag and drop a file into the Power Query canvas

2
19
47
Last week on #TransformTuesday the append operation was on the spotlight, this week is still about appending data but this time using the Combine files feature #PowerQuery docs.microsoft.com/power-que…
Combine files button inside the Combine group of the Power Query ribbon in the Home tab

ALT Combine files button inside the Combine group of the Power Query ribbon in the Home tab

File system view also known as table preview after connecting to a folder source where a column with the name Content is visible with an icon for combine files at the header right next to the name of the column.

ALT File system view also known as table preview after connecting to a folder source where a column with the name Content is visible with an icon for combine files at the header right next to the name of the column.

1
2
18
For this week #TransformTuesday we have one question for you. When was the last time that you used the Append transform? #PowerQuery docs.microsoft.com/power-que…
Power Query ribbon showcasing the Append queries and Append queries as new options

ALT Power Query ribbon showcasing the Append queries and Append queries as new options

Append queries dialog for Power Query where the option for "Three or more tables" is selected and multiple tables have been selected.

ALT Append queries dialog for Power Query where the option for "Three or more tables" is selected and multiple tables have been selected.

12
4
20
By far one of the most popular transforms used in #PowerQuery is Promote headers. Also, did you know that there's also a demote headers transform? Read more about it in the official documentation #TransformTuesday docs.microsoft.com/power-que…
The use first row as headers option shown in the table contextual menu of the Power Query editor

ALT The use first row as headers option shown in the table contextual menu of the Power Query editor

Use headers as first row option inside the Home tab of the Power Query editor

ALT Use headers as first row option inside the Home tab of the Power Query editor

2
6
37
Replying to @mahshadn
You won! :)

ALT Both Taco GIF
1
On this week's #TransformTuesday, we want to ask you a question about the Split column feature. Do you prefer to split your columns into columns or rows? #PowerQuery docs.microsoft.com/power-que…
Split column by delimiter dialog with the advanced options expanded to show the options to split into columns or rows

ALT Split column by delimiter dialog with the advanced options expanded to show the options to split into columns or rows

16
9
39
Check out what's new in the #PowerQuery experience found in @msexcel for Mac powerquery.microsoft.com/blo…
Choose data source dialog for the Power Query experience found in Excel for Mac

ALT Choose data source dialog for the Power Query experience found in Excel for Mac
5
19
Merge queries is our transform for today’s #TransformTuesday What’s the join kind that you most commonly use? Left outer? Right outer? Inner? Right anti? #PowerQuery docs.microsoft.com/power-que…
Merge queries dialog in Power Query

ALT Merge queries dialog in Power Query

8
9
45
For this #TransformTuesday, we have a transform that is the cornerstone of some of the most fun and interesting transform patterns out there: the add index column. What’s the most interesting query that you've done with this transform? #PowerQuery docs.microsoft.com/power-que…
Index column entry point inside the Add column tab of the Power Query ribbon

ALT Index column entry point inside the Add column tab of the Power Query ribbon

5
13
74
Monitor all your Dataflow refreshes with a #PowerBI dashboard powerapps.microsoft.com/en-u… #PowerQuery
Power BI report showcasing the multiple refreshes of a dataflow

ALT Power BI report showcasing the multiple refreshes of a dataflow

3
17
68
This week on #TransformTuesday, the spotlight goes to the Column From Examples feature. What do you think about this feature? Share your stories with us and tell us when was the last time that you used it #PowerQuery docs.microsoft.com/power-que…
Column From Examples feature within the Add Column tab in the ribbon of Power Query in Power BI Desktop

ALT Column From Examples feature within the Add Column tab in the ribbon of Power Query in Power BI Desktop

10
12
53
Have you used the query folding indicators (fka step folding indicators) in #PowerQuery online yet? Let us know what you think about them and any suggestions or feedback that you might have docs.microsoft.com/power-que…
Query folding indicators where the "Source" step is inconclusive, "Navigation" and "Removed columns" are shown as folded and the "Capitalized each word" and "Change column type" are not folded

ALT Query folding indicators where the "Source" step is inconclusive, "Navigation" and "Removed columns" are shown as folded and the "Capitalized each word" and "Change column type" are not folded

2
10
34
We are starting a new trend! #TransformTuesday Every Tuesday a new #PowerQuery transform will be on the spotlight. We are starting with Unpivot! Share your thoughts and stories about this transform and how you commonly use it docs.microsoft.com/power-que…
Unpivot columns menu in the transform tab of the Power Query ribbon

ALT Unpivot columns menu in the transform tab of the Power Query ribbon

16
45
231
Be sure to check our update on one of our most popular articles: The Get Data experience in #PowerQuery docs.microsoft.com/en-us/pow…
6
19
Replying to @AgulloBernat @notaboutthecell
You can click the thumbs down icon at the top right of the article to share your feedback. We read all messages and we value your feedback.
2
6
Happy Valentine's Day! Tell us how you fell in love with #PowerQuery, what feature you love the most about it or what you'd love to see next.
18
8
66
Load more