Forum Discussion
Advocate Icertificate chain was issued by an authority / PBI_SQL_TRUSTED_SERVERS
Case Closed. Using another connector helped to set up SQLs/connect to the database.
Using OLE DB was working well insted of SQL Server, which was working fine before the update.
Advocate IThank you very much.
Do you or someone else know another solution, because at the PC I don't have the admin rights to change general settings.
I am using Power Bi desktop and the server credentials differ from the windows log in, so I cant change from organizatorial account to windows account. Also the change of settings does not work for me eigther.
Or do somebody know where to write the condition
TrustServerCertificate=TRUE;
because my request is similar to:
Quelle = Sql.Database("Server", "database",
[Query="SELECT top 5 *
FROM table1"])
and not like #C where I can send some specifications also at the request...
Hi Do57792
This is a new issue that comes with the new version of Power BI Desktop (February 2024). If you are not able to add the environment variable, you can reverse Power BI Desktop back to the December version. That version doesn't have this issue. Download the history version from Previous monthly updates to Power BI Desktop and the Power BI service
In addition, you may try changing the following setting to None. As this is not listed as a workaround for this issue, I'm not sure if it would work or not. You may give it a try. Certificate revocation check, Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!- Do57792
I tried to use that setting, but nothing has changed. That was also described in another forum.