Power Query Dataflows
Dataflows are a self-service, cloud-based, data preparation technology that allows you to ingest, transform and load data into Common Data Service environments, Power BI workspaces or your organization's Azure Data Lake Gen2 account.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Standard | All Power Automate regions except the following: - China Cloud operated by 21Vianet |
| Power Apps | Standard | All Power Apps regions except the following: - China Cloud operated by 21Vianet |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | https://go.microsoft.com/fwlink/?linkid=2134674 |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://go.microsoft.com/fwlink/?linkid=2137921 |
| Categories | Productivity;Data |
| Privacy policy | https://privacy.microsoft.com/en-us/privacystatement |
To use this integration, you will need access to a product dataflows can be created in, such as Power BI, Power Apps etc.
To create a connection, select Sign In. You will be prompted to provide your work or school account, follow the remainder of the screens to create a connection.
You're now ready to start using this integration.
Known issues and limitations
Power Query Dataflows connector is not supported in sovereign cloud clusters (e.g. China, Germany) other than US Government Community Cloud.
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
| Frequency of trigger polls | 1 | 20 seconds |
Actions
| Refresh a dataflow |
Initiate a dataflow refresh operation. |
Refresh a dataflow
Initiate a dataflow refresh operation.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Group Type
|
workspaceType | True | string |
Select workspace or environment |
|
Group
|
groupIdForRefreshDataflow | True | string |
The unique identifier of the workspace or environment |
|
Dataflow
|
dataflowIdForRefreshDataflow | True | string |
The unique identifier of the dataflow |
Returns
The dataflow being refreshed
- Body
- DataflowModel
Triggers
| When a dataflow refresh completes |
This operation triggers when a dataflow refresh completes. |
When a dataflow refresh completes
This operation triggers when a dataflow refresh completes.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Group Type
|
workspaceType | True | string |
Select workspace or environment |
|
Group
|
groupIdForOnRefreshComplete | True | string |
The unique identifier of the workspace or environment |
|
Dataflow
|
dataflowIdForOnRefreshComplete | True | string |
The unique identifier of the dataflow |
Returns
An individual dataflow refresh
- Body
- RefreshModel
Definitions
DataflowModel
The dataflow being refreshed
| Name | Path | Type | Description |
|---|---|---|---|
|
Dataflow Name
|
dataflowName | string |
Name of the dataflow |
|
Dataflow Id
|
dataflowId | string |
Id of the dataflow |
RefreshModel
An individual dataflow refresh
| Name | Path | Type | Description |
|---|---|---|---|
|
Dataflow Id
|
dataflowId | string |
Id of the dataflow |
|
Dataflow Name
|
dataflowName | string |
Name of the dataflow |
|
Refresh Type
|
refreshType | string |
Type of the dataflow refresh |
|
Start Time
|
startTime | string |
Start time of the dataflow refresh |
|
End Time
|
endTime | string |
Completion time of the dataflow refresh |
|
Refresh Status
|
status | string |
Status of the dataflow refresh. Possible values are: 'Success', 'Failed', 'Cancelled' |