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.
Примітка
Each of these Power Query get data experiences contain different feature sets. More information: Where can you use Power Query?
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.
Get data in Excel (Windows or Mac)
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.
Примітка
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.
Get data in Power BI service
To get data in Power BI service:
On the left side of Power BI service, select Workspaces.
From the Workspace context menu, select the workspace you want to use.
From the workspace (in this example, TestWorkspace01), select New item.
From the New item page, under Get data, select the dataflow version you want to use (either Dataflow Gen1 or Dataflow Gen2).
If you select Dataflow Gen1:
From Define new tables, select Add new tables.
If you select Dataflow Gen2:
In the New Dataflow Gen2 dialog, enter the name of your new dataflow and then select Create.
In the Power Query editor, under the Home tab, select Get data.
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.
Get data in Power Apps
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:
Select New dataflow.
In the New dataflow dialog box, enter a name for your new dataflow.
Select Create.
Select the connector from the list of data sources.
Get data in Dynamics 365 Customer Insights
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.
Get data from Data Factory in Microsoft Fabric
To get data in Data Factory:
On the left side of Data Factory, select Workspaces.
From your Data Factory workspace, select New > Dataflow Gen2 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.
Get data in Analysis Services
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:
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.
You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
Продемонструйте методи та практичні поради, які відповідають бізнес-вимогам і технічним вимогам для моделювання, візуалізації та аналізу даних за допомогою Microsoft Power BI.
