topic Re: Manage Connection no longer shows on-prem connections in Dataflow

Manage Connection no longer shows on-prem connections

Joshrodgers123 — Tue, 05 Mar 2024 21:55:22 GMT

The manage connections page in PQ does not seems to be working correctly anymore. It is not showing any on-prem sources. It seems to only be showing cloud sources.

In the example below, I have a SQL Server data source, but the connection page is empty:

In this example, I have a SQL Server source and Lakehouse destination, but the connection page only shows the Lakehouse:

Here is one more example, but with Oracle:

Lastly, here is an attempt using a cloud connection to an Azure SQL DB. This time the connection does show:

Re: Manage Connection no longer shows on-prem connections

miguel — Tue, 05 Mar 2024 23:57:43 GMT

Could you share the M code for your On-Prem source?

Re: Manage Connection no longer shows on-prem connections

miguel — Wed, 06 Mar 2024 00:07:54 GMT

There was a bug last week and it was fixed recently so it should be rolling out soon to all regions. Hopefully we can rule out that its something else after seeing the M code for your On-Prem source query

Re: Manage Connection no longer shows on-prem connections

Joshrodgers123 — Wed, 06 Mar 2024 01:02:17 GMT

Here's an example for SQL Server:

let Source = Sql.Database(" ", " ", [CreateNavigationProperties = false]), #"Navigation 1" = Source{[Schema = "dbo", Item = "OrderLineItem"]}[Data] in #"Navigation 1"

Re: Manage Connection no longer shows on-prem connections

Joshrodgers123 — Sun, 10 Mar 2024 17:24:08 GMT

hi miguel - Do you know if my issue is related to the bug you mentioned? I checked today and still cannot see my data sources under Manage Connections.

Re: Manage Connection no longer shows on-prem connections

miguel — Tue, 12 Mar 2024 01:02:31 GMT

it could be related! if you still have the issue a week from now, please let us know. The fix is rolling out.

Re: Manage Connection no longer shows on-prem connections

Joshrodgers123 — Wed, 13 Mar 2024 02:14:50 GMT

miguel Fix went through and I can see the on-prem connections!

I did notice that when I click the pencil icon to edit the connection, then click cancel, it throws the below error. Not really hurting anything, but thought I'd point it out. The error is only thrown on gateway connections. Doesn't seem to happen on cloud connections

ResizeObserver loop completed with undelivered notifications.

undefined at https://us.prod.powerquery.microsoft.com/MashupEditor/?experience=power-bi&clientInstanceId=074e9fda-d586-4a56-b5dd-5985398624b0

Re: Manage Connection no longer shows on-prem connections

pqian_MSFT — Wed, 13 Mar 2024 03:58:12 GMT

Thanks for reporting this bug, will fix.