Forum Discussion
Advocate VData Refresh Errors after Enterprise Gateway upgrade
Super UserAfter upgrading to the October 2024 gatewaywhich one?
Did you notice the "Trusted Server" discussion in the release notes?
motorayI've just upgrade to 242.8. I hadn't seen the "Trusted Sever" discussion. Can you point me to that?
- lbendlin
I have had the same issue, but adding all the servers in the Config file as Trusted SQL servers, have resolved it! It doesnt look like a bug but something that we actually have to do going forward?? Can anyone confirm? Thanks
Link:On-premises data gateway October 2024 release | Microsoft Power BI Blog | Microsoft Power BI
- motoray
Never mind, I did find how to set it up over here:
https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trusted-on-the-client-power-bi-desktop-or-on-premises-data-gatewayWe don't use encrypted connections internally yet, so this may very well have something to do with it.
Your solution is so great lbendlin
Hi, motoray
The current error is that it is now the default behavior for all PBI desktop and gateway versions that are equal to or higher than the February 2024 release.
Solved: Assistance Required with SQL Server Standard Mode ... - Microsoft Fabric Community
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.