@MSPowerQuery

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

 Redmond, Washington
powerquery.com
Joined September 2020
  • Tweets82
  • Following11
  • Followers4.6K
Implement Native Query support in your #PowerQuery Custom Connectors powerquery.microsoft.com/en-…
2
11
38
6,347
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
61
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
4
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
2
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
2
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
2
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
1
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
1
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
4
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
2
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
2
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
1
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
3
47
Load more