topic Re: BUG::MS SQL error when connecting to a lakehouse directly from LH name list in UI in Dataflow

BUG::MS SQL error when connecting to a lakehouse directly from LH name list in UI

Element115 — Tue, 23 Jan 2024 04:44:34 GMT

STEPS:

0__open existing Dataflow Gen2

1__right click in query pane and select New Query-->More...

2__In the Get Data-Choose data source dialog that opens, click on the name of the exisiting lakehouse (that the user created in a previous step) in the OneLake data hub pane under the New sources section

3__here is the screenshot of the error message that appears:

And the same occurs when selecting More... from the New Sources section and proceeding to choose Lakehouse and just going through all the prompts after that:

Re: BUG::MS SQL error when connecting to a lakehouse directly from LH name list in UI

v-cboorla-msft — Tue, 23 Jan 2024 18:14:16 GMT

Hi Element115

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

I tried to repro the same steps mentioned in the ask. I didn't find any difficulty in accessing the Lakehouse. Please find the screenshots for reference.

Could you please try once and let us know if the issue still persists. Gald to help.

Hope this helps.

Re: BUG::MS SQL error when connecting to a lakehouse directly from LH name list in UI

Element115 — Tue, 23 Jan 2024 19:12:23 GMT

After posting, I realized something that might have a bearing on this. The DF I had re-opened for edit--I was trying to add a second query in it--well, the DF had already run with one query, and the DF was published without specifying a destination, so that the one query would not get persisted to any user created LH.

When I tried to add a second query to the second DF in the chain, DF which was persisted this time to a user created LH, no such error message would pop up.

If that is the cause, it might be a good idea to generate a more user-friendly error message explaining better what the cause of the error or rather, why some action cannot be performed as intended.

Re: BUG::MS SQL error when connecting to a lakehouse directly from LH name list in UI

v-cboorla-msft — Tue, 13 Feb 2024 09:55:34 GMT

Hi Element115

Apologies for the delay in response from my end.

Following up to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

Re: BUG::MS SQL error when connecting to a lakehouse directly from LH name list in UI

v-cboorla-msft — Fri, 16 Feb 2024 05:07:29 GMT

Hi Element115

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.