https://community.fabric.microsoft.com/t5/Developer/SupportsEncryption-property/m-p/4021495#M53859 <P>HI&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/769385">@okramarenko</a>,</P> <P>Perhaps you can take a look at the following description about encryption connection if helps.</P> <P>Encrypted Connection in Power Query ensures that data transferred between your data source and your Power Query client is encrypted for security purposes.</P> <P>Keypoints of encryption connections:<BR /><STRONG>Security</STRONG>: Encrypted connections help protect sensitive data during transmission. They prevent unauthorized access or interception of data by encrypting it using secure protocols.</P> <P><STRONG>Data Sources</STRONG>: Encrypted connections can be used with various data sources, including databases (e.g., SQL Server, MySQL), cloud services (e.g., Azure SQL Database), and other APIs.<BR /><STRONG>Encryption Protocols</STRONG>: Power Query supports encryption using protocols such as TLS (Transport Layer Security). When you enable an encrypted connection, Power Query inovke secure channel with the data source using these protocols.<BR /><STRONG>Authentication</STRONG>: Encrypted connections work alongside authentication methods (e.g., username/password, OAuth tokens). (the combination of encryption and authentication ensures data integrity and confidentiality)<BR /><STRONG>Configuration</STRONG>: To use an encrypted connection, you typically need to specify the data source’s server name, database name, and authentication details. (Power Query will handles the encryption automatically)</P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Wed, 03 Jul 2024 01:39:44 GMT Anonymous 2024-07-03T01:39:44Z https://community.fabric.microsoft.com/t5/Developer/SupportsEncryption-property/m-p/4020554#M53846 <P>I'm working on a custom Power BI connector and encountered the <STRONG>SupportsEncryption</STRONG> property (<A href="https://learn.microsoft.com/en-us/power-query/handling-data-access" target="_new" rel="noreferrer">https://learn.microsoft.com/en-us/power-query/handling-data-access</A>). When set to<STRONG> true</STRONG>, it prompts a new window that allows users to choose whether they want their connection to be encrypted. However, this option appears to only work in <STRONG>Power BI Service</STRONG>. Could someone please provide more details on how this works for <STRONG>Power BI Desktop</STRONG>? I haven't been able to find any information about this. Thank you in advance.</P> Tue, 02 Jul 2024 13:20:36 GMT https://community.fabric.microsoft.com/t5/Developer/SupportsEncryption-property/m-p/4020554#M53846 okramarenko 2024-07-02T13:20:36Z https://community.fabric.microsoft.com/t5/Developer/SupportsEncryption-property/m-p/4021495#M53859 <P>HI&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/769385">@okramarenko</a>,</P> <P>Perhaps you can take a look at the following description about encryption connection if helps.</P> <P>Encrypted Connection in Power Query ensures that data transferred between your data source and your Power Query client is encrypted for security purposes.</P> <P>Keypoints of encryption connections:<BR /><STRONG>Security</STRONG>: Encrypted connections help protect sensitive data during transmission. They prevent unauthorized access or interception of data by encrypting it using secure protocols.</P> <P><STRONG>Data Sources</STRONG>: Encrypted connections can be used with various data sources, including databases (e.g., SQL Server, MySQL), cloud services (e.g., Azure SQL Database), and other APIs.<BR /><STRONG>Encryption Protocols</STRONG>: Power Query supports encryption using protocols such as TLS (Transport Layer Security). When you enable an encrypted connection, Power Query inovke secure channel with the data source using these protocols.<BR /><STRONG>Authentication</STRONG>: Encrypted connections work alongside authentication methods (e.g., username/password, OAuth tokens). (the combination of encryption and authentication ensures data integrity and confidentiality)<BR /><STRONG>Configuration</STRONG>: To use an encrypted connection, you typically need to specify the data source’s server name, database name, and authentication details. (Power Query will handles the encryption automatically)</P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Wed, 03 Jul 2024 01:39:44 GMT https://community.fabric.microsoft.com/t5/Developer/SupportsEncryption-property/m-p/4021495#M53859 Anonymous 2024-07-03T01:39:44Z