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
Allow the target pipeline reference in Invoke Pipeline / ExecutePipeline to be set dynamically
Problem Today, the Invoke Pipeline activity (and legacy ExecutePipeline) requires picking the target pipeline statically at design time — a fixed Workspace/Pipeline selection in the UI, which serial...JONATHANHAUN12 hours agoNew MemberNew8Views0likes0CommentsReset Bookmark Navigator Selection to the Default Published View on Browser Refresh
In Power BI Service, when a user selects a bookmark through a Bookmark Navigator, the bookmark identifier is appended to the report URL. If the user refreshes the browser page, the report reloads in ...vivek1234413 hours agoMicrosoft EmployeeNew6Views0likes0CommentsSeparate Interactive and Background Compute Allocation to Prevent Throttling of Live Reports
Problem Statement When Fabric capacity utilization reaches or exceeds 100% in the last one-hour window, end users experience significant disruptions when accessing Power BI Fabric live reports. This...TilakArani13 hours agoNew MemberNew8Views0likes0CommentsAccessibility issue in the Share dialog of embedded Power BI reports
Accessibility issue in the Share dialog of embedded Power BI reports I would like to share an accessibility finding identified while testing an embedded Power BI report published as part of the cont...ugartema14 hours agoAdvocate INew113Views15likes1Comment- fbcideas_migusr16 hours agoNew MemberUnder Review387Views12likes4Comments