Unanswered

Not able to fetch table from On Premise SQL Database

(0) Share

Report

Posted on by Community Power Pla...

Hello Experts ,

I have one simple flow which transfer data from SP list to SQL. before this flow was working fine , now i am trying to change the table in the same connection but it gives below error.

I have tried below :

Refresh the page and sing in sign out

adding SQL connection again but it gets connected with SQL server but does not fetch the table

i was trying and deleting connection but i am not able to access connection page.

Please advise on this with my old table it still working fine

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Hi @Anonymous ,

Have you tried entering the exact name of table in custom value ? Check if that works.

You may also refer this:
https://powerusers.microsoft.com/t5/Connecting-To-Data/SQL-Server-using-On-Premises-Gateway-cannot-retrieve-tables/m-p/329415

Was this reply helpful? Yes No
Priyae on at

Like (1)

Report

Hello @Anonymous ,

Entering the exact table name should work the wonder .

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @Anonymous , @pre Yes i have tried entering table name as custom value , That time it shows this error.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello Guys ,Can anyone suggest something still i am not able to connect to my On Premise SQL DB

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello GUys ,

I just figured out something that other table are appearing now after deleting and connecting SQL connection but my Table is still not appearing.
May be because this table i have created in Visual Studio D365 F&O model. Did anyone have idea what configuration i should check to get that table in power Automate

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Hello Guys
My issue has been solved , i have deleted and recreated the table also this time i have entered the table name in Caps . now i can load table in Power Automate.
I believe when you are fetching table in PA , its case sensitive. you must use same table name case as created in SQL side.

Was this reply helpful? Yes No