Answered

SQL server connection not showing up in drop down

(0) Share

Report

Posted on by pnepal

I have multiple SQL servers and databases in my connections. While doing power query or get rows(V2), I only get one server as an option rather than all of the existing connections. I have double-checked all connections, and they are all connected. Why is the Get rows not showing all the connected servers and databases?

Using a custom value with the same database and server name does not help either. Is there a way to fix this?

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Hi @pnepal ,

Sorry for there is no any way to achieve the requirement since Microsoft flow could only get the rows from the table in the selected connection for the sql server.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
pnepal 13 on at

Like (0)

Report

HI @v-alzhan-msft ,

I am having issues with server and database not showing up in the drop down. They are established connections in Data-> connections but they do not show up while selecting the server or database except the most recent server.

I do understand flow can only get the rows from the selected connections, my issue is with selecting those connections. I am not getting options of all available sql connections I have.

Two attachments to this response to describe my issue. The first one shows all the SQL connections I have. The second one shows inside the flow, I only have one option for SQL connection(the most recent one). How would I be able to get data from other connections? Its the same issue with all SQL operations including Power Query.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (2)

Report

Hi @pnepal ,

You could choose the connection by clicking the "..." icon.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
pnepal 13 on at

Like (0)

Report

Thank you, I could not figure this out for a long time.

Was this reply helpful? Yes No
InfinityAlarm 15 on at

Like (0)

Report

It took me a bit, but I finally figured out exactly where to click to get this fixed:
Hope this helps someone in the future! ❤

Was this reply helpful? Yes No