Unable to get tablename using on Prem data gateway

New Contributor

Hi

 

I'm using an on-prem data gateway to read / write data to an on-prem SQL server using a flow.

 

It's possible to get the connection to the server and the Database but I'm always getting tables names as : #A5B94499, #A2CD3DD, etc. See attached image

 

Does anyone has this problem ? 

1 Reply

Hi @BryanLewis82 

 

Here is some details to clarify my problem.

 

We have a SQL server on Premise (local) on which we installed the "Onpremise data gateway" . 

"The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services". 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

 

Inside a specific Flow (power automate) we need to read data from  our onPremise database tables.

 

There is a couple of available actions in powerautomate to work with SQL server data https://docs.microsoft.com/fr-fr/connectors/sql/#update-row-(v2)) .

 

If I try to begin with a simple case : get rows from a table (see my attached images)

- I'm able to create the connection to the server using my data gateway

- I'm able to choose my server and database in the Get rows (v2) action. 

- When I try to specify on which table I want to make the query, the dropdown gives me a list of tables that does not exist in the database.

 

My Database is named : tempDB

It contains only 3 tables inside : test1, test2, test3

Powerautomate show me a liste of weird coded name formatted as #ad254342.

 

I even tried to choose one of these "table" to test but, obviously, since the table does not reaaly exist, POwer automate return the error "the table does not exist".

 

So, I would like to know what is wrong ?

is it possible to use the SQL Server actions through an On Prem data gateway ?