Forum Discussion
Advocate VData Refresh Errors after Enterprise Gateway upgrade
Advocate VNever 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-gateway
We 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.
- motoray
Unfortunately in my case this did not correct the problem. I continue to have refresh failures after adding trusted SQL servers to the config. Same error as below--with the name of the table randomly being a table from the model.
{"error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Random Table Name.- lbendlin
Super User
Since you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
