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
Why are Calculation Groups so hard to modify?
Is there a way to make it easier to modify the DAX in a calculation group? I'm not sure if it's just me that finds this so annoying, but perhaps it's because I just started using calculation groups. ...AaronReasoner56 minutes agoNew MemberNew2Views0likes0CommentsFeature Request: Add a Warning Prompt Before Deleting Tables That Contain Measures
Problem Statement: In Power BI, measures are linked to specific tables. When a developer deletes a table from the model view or report view, Power BI automatically deletes all measures assigned to ...Murtaza_Ghafoor3 hours agoSuper UserNew11Views2likes0CommentsCustom visuals: allow same-tab navigation & reduce confirm-navigation friction for trusted links
Description: Custom visuals (e.g. Deneb) that trigger navigation via href currently have two limitations that create friction for legitimate, author-controlled use cases: Links always open in a ne...AlexSenEON5 hours agoNew MemberNew8Views0likes0CommentsSeparate Download and Publish Permissions for Power BI Workspaces
Idea / Feature Request Introduce more granular permissions in Power BI to independently control report download and report publishing permissions at the workspace level. Business Scenario We have ...ewarstdhyjugkhi6 hours agoMicrosoft EmployeeNew23Views8likes0Comments