# certificate chain not trusted data refresh error in power bi - Link: https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/ - Published: 2024-08-13T02:26:00+05:30 - Author: Deviprasad Panda The certificate chain was issued by an authority that is not trusted error in power BI desktop application. User trying to refresh data from power bi desktop application. User getting error Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.). There is no error if user refresh power bi data from online portal. User using sql server data connection with power bi as data source. ![The certificate chain was issued by an authority that is not trusted](https:// i0.wp.com/sharepointtechnicalsupport.com/wp-content/uploads/2025/06/2cd90-certificate- chain-not-trusted.jpg?resize=584%2C424&ssl=1 "The certificate chain was issued by an authority that is not trusted") The certificate chain was issued by an authority that is not trusted Advertisements Follow the step-by-step procedure below to resolve the power bi data source certificate not trusted error. * Open Power BI desktop software application. * Click on Transform Data from the ribbon section Data. * Select Data source settings from the drop down. ![data source settings power bi](https://i0.wp.com/sharepointtechnicalsupport.com/ wp-content/uploads/2025/06/495fa-data-source-settings-power-bi.png?resize=584%2C232& ssl=1 "Navigate to Transform data and click on Data source settings") data source settings power bi Advertisements * Select the power bi data source. * Click on Edit Permissions to check or change the microsoft power bi data souce connection with sql server. ![edit power bi data source connection](https://i0.wp.com/sharepointtechnicalsupport. com/wp-content/uploads/2025/06/98ad4-edit-power-bi-data-source-connection.png?resize =584%2C432&ssl=1) edit power bi data source connection Advertisements * Edit Permissions window will open. Click on the Edit present under Credentials. ![edit power bi data source connection credentials](https://i0.wp.com/sharepointtechnicalsupport. com/wp-content/uploads/2025/06/b318b-edit-power-bi-data-source-connection-credentials. png?resize=358%2C513&ssl=1) edit power bi data source connection credentials Advertisements * New window will open and you will find the current power bi data source connection type with sql server is selected as Microsoft account or [Datatbase](https://sharepointtechnicalsupport.com/category/content-databases/). ![current power bi data source connection type](https://i0.wp.com/sharepointtechnicalsupport. com/wp-content/uploads/2025/06/3b57a-current-power-bi-datat-source-connection-type. png?resize=584%2C262&ssl=1 "current power bi data source connection type") current power bi data source connection type * You just need to switch the power bi data source sql server connection type to Windows. ![switch connection type to windows](https://i0.wp.com/sharepointtechnicalsupport. com/wp-content/uploads/2025/06/54e64-switch-connection-type-to-windows.png?resize =584%2C261&ssl=1 "switch connection type to windows") switch connection type to windows Advertisements * Keep the selection for Encryption (Encrypt connections) and Privacy Level (Public, Organizational, Private) as selected belore. CLickon OK finally. ![encryption privacy level](https://i0.wp.com/sharepointtechnicalsupport.com/wp- content/uploads/2025/06/b5ecd-encryption-privacy-level.png?resize=359%2C518&ssl= 1 "encryption privacy level") encryption privacy level * Now issue should be resolved. If user tries to refresh data from [power BI](https://youtu.be/aGfb8ZrKu5I) desktop, there should not be any data refresh error. Advertisements You can follow the steps in the video below since many users more comfortable in video format FYR. certificate chain not trusted sql server error microsoft power bi desktop | data refresh error Advertisements ### Share this: * [ X ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?share=twitter) * [ Facebook ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?share=facebook) * [ WhatsApp ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?share=jetpack-whatsapp) * [ Email ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?subject=%5BShared%20Post%5D%20certificate%20chain%20not%20trusted%20data%20refresh%20error%20in%20power%20bi&body=https%3A%2F%2Fsharepointtechnicalsupport.com%2F2024%2F08%2F13%2Fcertificate-chain-not-trusted-data-refresh-error-in-power-bi%2F&share=email) * [ Telegram ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?share=telegram) * [ LinkedIn ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?share=linkedin) * [ Tumblr ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?share=tumblr) * [ Pinterest ](https://sharepointtechnicalsupport.com/2024/08/13/certificate-chain-not-trusted-data-refresh-error-in-power-bi/?share=pinterest) ### Like this: Like Loading… ### _Related_