Forum Discussion

CeeVee33's avatar
CeeVee33
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Fabric LH/WH Encryption with PBI Desktop

Hi Experts -   I'm reaching out for a weird action by Fabric Lakehouse & Warehouses.   In SSMS - when I am at home on VPN, I connect to them with "Mandatory" Encryption. when I am in office on...
data warehouse
Mirrored Azure SQL Database
warehouse
  • CeeVee33's avatar
    CeeVee33
    1 year ago

    Hi Anonymous 

     

    It appears that when the firewall rules were set up, they just had TDE rules i.e. Transparent Data Encryption rules related to mssql-db-encrypted . They had to add ssl as well.

     

    Thank you for your help

SamsonTruong's avatar
SamsonTruong
Icon for Super User rankSuper User
1 year ago

Hi CeeVee33 ,

When you are connecting to the LH/WH in Power BI Desktop, are you using the SQL Server connector and using the SQL Analytics Endpoint?

If so, can you try accessing the LH/WH through the OneLake catalog instead and see if it still generates an error when attempting to connect?

 

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson