Forum Discussion
Certificate Chain Not Trusted Error affecting PBI only, can't switch credentials to Windows.
I spoke to microsoft support and they told me it's an issue that they're aware of. A workaround can be found here:
However this did not work for me, but may be helpful to other people. Support couldn't confirm when the issue would be resolved but I'm hoping the March 2024 PowerBI desktop release fixes the issue.
Workaround: I downloaded the December 64-bit version and the problem disappeared....
https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-desktop
Can confirm this workaround works, however it is not ideal as Microsoft guidance is to use the newest version of PowerBI as it is the only one technically supported.
Yes, it works. You don't have much choice until someone provides a resolution for the Feb 24 version.
I have encountered the same issue. There are two solutions (workarounds)
1) Roll-back to Dec 2023 (Micrsoft support has confirmed this to me)
2) I was able to bypass the error by inserting a space before the port# in connection string (connecting to SQL):
old connection: SV944007\CR1001,27692modified conneciton: SV944007\CR1001, 27692
Note - if you have an alreay published old connection string, it wont be recognized in the Gateway. You have to create a new gateway connection with the modified connection string.
please try this and confirm if this works
I have the same issue with March 202r version. Miscrsoft's workaround solution was to rollback to DEC 2023.