Microsoft query tool

If you own a data source or service and want to make it easily accessible to others, check out how to build and certify your custom Power Query connector. Technical explanations written by the creators of Power Query. Everything you want to know about the language that powers Power Query. Books, blogs, training, and links to everything Power Query. Data prep done smart, fast, easy Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.

Get started. What's new. Nov 15 Nov 15 Nov 8 Oct What is Power Query? Connect to hundreds of data sources. Search connectors. Accessible, powerful, smart data preparation. No coding needed. Now we need to select the Excel file that will be the source for our Microsoft Query.

Otherwise select your Columns. Now you have two options:. When you are done hit the return button the one with the open door. When you are done modifying your SQL statement as I in previous step. Click the Return data button in the Microsoft Query window. This should open the Import Data window which allows you to select when the data is to be dumped.

Lastly, when you are done click OK on the Import Data window to complete running the query. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful?

Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page. View all page feedback. In this article. Azure Data Studio.