Share via


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

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

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'