Errors trying to refresh power platform dataflow (uses vnet gateway and Azure sql database)

Hi,

When try any of the following get error using power platform dataflows

1) When try set new link to data lake and choose our storage account such that results of dataflow are stored in our storage account get error below.

does not have authorization to perform action 'Microsoft.Authorization/roleAssignments/write' over scope '/subscriptions/<guid>/resourceGroups/rg-adw-dev-001/providers/Microsoft.Storage/storageAccounts/dlsadwdev001/providers/Microsoft.Authorization/roleAssignments/<guid>' or the scope is invalid. If access was recently granted, please refresh your credentials."}

2) When publish a dataflow get message when it tries to refresh get error below.

Gateway proxy unable to connect to Data Lake (host: '<mshost>.dfs.core.windows.net'). Learn how to troubleshoot this connectivity issue here: https://learn.microsoft.com/data-integration/gateway/service-gateway-tshoot#gateway-proxy-unable-to-connect-to-managed-data-lake. (Request ID: <guid>).

Can build dataflow and see the data and publishes succesfully (uses vnet data gateway and azure sql database).

How can we create power platform dataflow which refreshes successfully using vnet gateway and azure sql database.

Can use power bi datasets o.k. with vnet data gateway and azure sql database but looking to also to use power platform dataflows

Thanks

Categories:

Microsoft Dataverse

Dataflows

Quick Links

Subscribe to this forum!