Where to get data
Getting data from available data sources is usually the first encounter you have with Power Query. This article provides basic steps for getting data from each of the Microsoft products that include Power Query.
Note
Each of these Power Query get data experiences contain different feature sets. More information: Where can you use Power Query?
The procedures for where to start getting data in Power BI Desktop are described in Data sources in Power BI Desktop.
In Power BI Desktop, you can also directly select an Excel worksheet, a Power BI semantic model, a SQL server database, or Dataverse data without using the Get data option. You can also enter data directly in a table, or select from a data source that was recently used.
To get data in Excel for Windows or Excel for Mac:
From the Data ribbon, select Get Data.
Scroll through the category selections in the get data context menu, and select the connector you want to use.
You're then asked to fill out the required information for you to access the data. Go to the individual connector articles for more information about this required information.
In Excel for Windows, you can also directly select Text/CSV, Web, and Excel worksheet data without using the Get Data option. You can also select from a data source that was recently used and from existing connections or tables.
Note
Not all Excel versions support all of the same Power Query connectors. For a complete list of the Power Query connectors supported by all versions of Excel for Windows and Excel for Mac, go to Power Query data sources in Excel versions.
To get data in Power BI service:
On the left side of Power BI service, select Workspaces (but not My Workspace).
From the Workspace context menu, select the workspace you want to use.
From the workspace (in this example, TestWorkspace01), select the context menu next to New.
From the New context menu, select Dataflow.
From Define new tables, select Add new tables.
In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.
If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.
There are several places in Power Apps where you can get data, either by importing data to a table or by creating a dataflow.
To import data to a new table in Power Apps:
On the left side of Power Apps, select Dataverse > Tables.
In the Tables pane, at the top left, select Import > Import data.
You can also choose to get data directly from an Excel worksheet without using the Import data option.
In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.
If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.
To import data to an existing table in Power Apps:
On the left side of Power Apps, select Dataverse > Tables.
In the Tables pane, either:
Select a table in the Tables pane that you want to import data to, and then select Import > Import data.
Open the table to its individual pane, and then select Import > Import data.
In either case, you can also choose to get data from an Excel worksheet without using the Import data option.
Select the connector from the list of data sources.
To get data in Power Apps when creating a dataflow:
On the left side of Power Apps, select Dataverse > Dataflows.
If a dataflow already exists:
- Double-click on the dataflow.
- From the Power Query editor, select Get data.
- Select the connector from the list of data sources.
If no dataflow exists and you want to create a new dataflow:
To get data in Customer Insights:
On the left side of Customer Insights, select Data > Data sources.
In the Data sources pane, select Add data source.
In Choose your import method, choose Microsoft Power Query.
In Save data source as, enter a name for your data source.
Select Next.
In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.
If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.
To get data in Data Factory:
On the left side of Data Factory, select Workspaces (but not My Workspace).
From your Data Factory workspace, select New > Dataflow Gen2 (Preview) to create a new dataflow.
In Power Query, either select Get data in the ribbon or select Get data from another source in the current view.
In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.
If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.
With Analysis Services, a solution is developed in Visual Studio with the Analysis Services projects extension. The solution is then deployed to SQL Server Analysis Services, Azure Analysis Services, or a Power BI Premium workspace.
The Analysis Services documentation contains the following information that describes the process for getting data:
To set up a Visual Studio solution with the Analysis Services projects extension: Create a tabular model project
To get data: Get data
There are a couple of places in Power Automate where you can get data, either by importing tables or in process adviser.
To get data by importing tables:
On the left side of Power Automate, select Data > Tables. At this point, a new tab with Power Apps opens in your browser.
In the Power Apps tab, follow the instructions for importing data to either a new table or to an existing table in the Power Apps section.
For information about how to get data in process advisor, go to Connect to a data source.
Azure Data Factory doesn't use the same Power Query get data interface as the other apps described in this article. Instead, Azure Data Factory uses its own built-in functionality to import data.
However, Azure Data Factory does use Power Query to transform data in data wrangling. The following Azure Data Factory articles describe how to use Power Query for data wrangling:
SQL Server Integration Services (SSIS) doesn't use the same Power Query get data interface as the other apps described in this article. Instead, SSIS uses its own built-in functionality to import data.
For information on installing, configuring, and using the Power Query Source for SSIS, go to Power Query Source.