Forum Discussion

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

BUG::NETWORK::IDBConnection::partial pre-login handshake failure

ISSUE:

A report created with PBI Desktop that uses a Fabric lakehouse as its datasource in DirectQuery mode has experienced the following error when navigating from one page to the one you see in the screenshot.  In other words, when you navigate to a page for the first time, as here was the case, PBI Desktop needs to load the data from the lakehouse.  Some data comes through as some visuals populate, but not others. All data for all the visuals come from the same lakehouse table.

 

The error message is:

The M code for the model table is as follows:

let
    Source = Sql.Database("45asfd5s4f6.datawarehouse.fabric.microsoft.com", "LH_RWS"),
    dbo_FACT_RWS_M15 = Source{[Schema="dbo",Item="FACT_RWS_15M"]}[Data]
in
    dbo_FACT_RWS_M15

 

Then after dismissing the dialog, navigating away and back to the page, the error went away and the remaining viz loaded properly. 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Element115 

     

    This may caused by the lack of the certificate in SQL Server configuration.

    Please try this:

    In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.

    Right-click Protocols for <instance Name>, and then select Properties.

    Choose the Certificate tab, and then select Import.

    Select Browse and then select the certificate file.

    Select Next to validate the certificate. If there are no errors, select Next to import the certificate to the local instance.

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

      Anonymous  If it were a lack of certificate, then why do some viz load fine, but not others?  The source is the same table in a lakehouse via the lakehouse SQL analytics endpoint.  

       

      And why does every viz load properly again upon navigating to another page and then back to this page?

       

      Meaning if it were a certif issue, wouldn't this mean that all viz shouldn't load no matter what you do in the PBI Desktop GUI?