Forum Discussion
Certificate Chain Not Trusted Error Effecting PowerBI Only
- 2 years ago
Thank you Anonymous !
I ended up adding an ODBC Driver 17 for SQL Server Connector and accessing the data in Power BI through ODBC instead and it seems to work.
Thanks again!
Christina
Thanks for your quick reply, I can feel your effort.
Here is my solution to your question:
1.First of all,if you want to log in using SQL Server Authentication, you can also try it, except that the first step is different, the other steps are the same. I'm not sure if your sql account can create a new login, but you can try it, it's the easiest way I've found so far.
2.In my research on your problem, I found a screenshot of an error similar to yours:
If you also encounter this problem, you can try clicking on the icon below
3.And, if you are not sure which CA is missing, you may need to contact your IT department or SQL Server's administrator for more help. What we can see now is limited.
If you need any further help, please don't hesitate to let me know. I will do my best to support you.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous !
I ended up adding an ODBC Driver 17 for SQL Server Connector and accessing the data in Power BI through ODBC instead and it seems to work.
Thanks again!
Christina