For PostgreSQL source semantic model failing but dataflow refreshing successfully
Getting below error while refreshing semantic model for which we are using Postgresql source
Getting below error while refreshing semantic model for which we are using Postgresql source
DataSource.Error: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'. Microsoft.Data.Mashup.ErrorCode = 10434. DataSourceKind = PostgreSQL.
As per official document gateway is mandatory to connect PostgreSQL which is hosted on AWS server.
But for the same source dataflow is working fine without any gateway for the same source.
As the PostgreSQL is hosted on cloud so semantic model must be refresh without gateway.
2 Comments
- andy_claphamNew Member
It is a know problem. MS do not trust AWS certificates. You cannot directly refresh from AWS cloud postgres. You can use an onprem-gateway, or move to Azure postgres.
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Support Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull225 hours agoAdvocate INew45Views1like2CommentsMake Eventgrid Namespace MQTT broker part of Fabric
In Azure, this plain MQTT broker is offered as part of the Event Grid Namespace. Technically, this is a great broker, but it lacks usability because the UX in the portal is designed by a spartan. Y...svelde5 hours agoSuper UserNew22Views6likes0CommentsBring back auto refresh for real time dashboards
I have a potential client for streaming data and real time dashboards. I'm setting up a mock up, pushing data every few seconds. Everything is connected, but the Real Time Dashboard is 15 MINUTES beh...ToddChitt6 hours agoSuper UserCompleted817Views4likes3Comments