Forum Discussion

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

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

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:

Dataflows

4 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    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.

     

     

     

    • Element115's avatar
      Element115
      Icon for Memorable Member rankMemorable Member
      2 years ago

      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.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        2 years ago

        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.