Power Platform Community Forum Thread Details

Hi all,

We have an issue when trying to setup a dataflow and pull on-premise data into a Dataverse table.

Here are the steps we followed:

Create and install a new data gateway on a server that has access to the SQL server --> OK
Setup a Windows account (domain\user) to access SQL server views --> OK
Create a new "SQL Server database" connection with the data gateway of step 1 and the user account of step 2 --> OK
1. The connection is online
2. We tested the connection in a flow and it works
Create a new dataflow of type "SQL Server database" to use the SQL connection of step 3 --> NOK
1. We can select the connection created
2. We click "next" and get an "Invalid credentials" error
3. We tried setup the connection manually (without using the existing connection) and have the same problem
Try with "Get data" from the Dataverse tables instead of creating a dataflow and repeat same as step 4 --> NOK

What is strage is that nothing change in the configuration between the Connection that work and the Dataflow that fails (image below). We use the same datagateway, the same authentication type, the same user/password, etc. and it does not work for the dataflow...

Jaimé_0-1623400826889.png