Unanswered

How to use SQL server connection in Project Oakdale

(0) Share

Report

Posted on by MGerdis

Hi,

I am able to create an SQL Server connection in Oakdale but I cannot figure out how to use the connection to access on-prem tables. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MGerdis ,

Could you please share more details? What problem did you meet when connecting to tables in SQL Server?

Below are screenshots of connecting to tables in SQL server with created SQL Server connector:

If you could not connect to the table with in Teams Desktop Client, please try web client instead:
https://teams.microsoft.com/

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
MGerdis 4 on at

Like (0)

Report
Copy link

Link copied!

I can create a new connector and it is in the Oakdale environment, but not in my app, and the list of table to choose from is not available like it is in regular Power Apps.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MGerdis ,

Have you fixed the issue?

If not, do you mean you could not see the Choose a table panel after clicking that SQL Server connection? The panel it did not come up or no tables in it? Please share more details of the situation.

Advice for supplement, you need to double check the authentication of SQL Server, and also need to make sure that gateway is working.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No