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 th...
Need Help
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?