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
29 Photos and videos
Filter
Exclude
Time range
-
Minimum likes
Check out the new community forum where you can talk or ask questions around pipelines and #PowerQuery dataflows in #MicrosoftDataFactory community.fabric.microsoft.c…
5
31
9,277
Try #PowerQuery Dataflows today in #MicrosoftFabric and #MicrosoftDataFactory Read more about it from @weehyong latest blog post blog.fabric.microsoft.com/en…
4
24
8,264
Learn about newly released support for native queries in the Azure Databricks Power Query connector! powerquery.microsoft.com/blo…
1
13
30
6,548
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
A new #PowerQuery function is out! Check out our latest blog post written by @cwebb_bi about it powerquery.microsoft.com/en-…

What Is Power Query? - Power Query

Learn what Power Query is, and how it can help you get and transform data

learn.microsoft.com
5
25
Read about our release of Azure AD-based Single Sign-On for Dremio Cloud and Power BI! powerquery.microsoft.com/en-…

What Is Power Query? - Power Query

Learn what Power Query is, and how it can help you get and transform data

learn.microsoft.com
2
8
We are excited to announce the Public Preview release of our new Power Query SDK for Visual Studio Code! powerquery.microsoft.com/en-…
1
14
56
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
We just released 80+ new data connectors in #powerquery online, allowing users to prep data from anywhere and any size using #powerbi #dataflows and #datamarts! powerquery.microsoft.com/en-…

What Is Power Query? - Power Query

Learn what Power Query is, and how it can help you get and transform data

learn.microsoft.com
1
12
46
What is your favorite #PowerQuery connector and why? Today in #TransformTuesday we want to know about your best experience with a data connector. Tell us about it! docs.microsoft.com/power-que…

List of all Power Query connectors - Power Query

List of all currently available Power Query connectors

learn.microsoft.com
5
4
19
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
A new blog post on #PowerQuery query folding by the one and only @notaboutthecell ! An introduction to query folding powerquery.microsoft.com/en-…
10
38
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
The #PowerQuery team is looking for a new Sr. Product Manager. Click the link below for more information: careers.microsoft.com/us/en/…
1
7
8
While using #PowerQuery, which transform do you usually use to select / remove columns from your query? Share your experiences as a reply to this tweet! #TransformTuesday docs.microsoft.com/power-que…
59% Choose columns
41% Remove columns
160 votes • Final results
9
2
8
Load more