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.
Power Query Dataflows connector is not supported in sovereign cloud clusters (e.g. China, Germany) other than US Government Community Cloud.
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
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.
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
Frequency of trigger polls | 1 | 20 seconds |
Refresh a dataflow |
Initiate a dataflow refresh operation. |
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
When a dataflow refresh completes |
This operation triggers 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
The dataflow being refreshed
Name | Path | Type | Description |
---|---|---|---|
Dataflow Name
|
dataflowName | string |
Name of the dataflow |
Dataflow Id
|
dataflowId | string |
Id of the dataflow |
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' |