Forum Discussion
Solved
Power BI Service Refresh Failing Intermittently for PostgreSQL Source
Error
Data source error: {
"error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"pbi.error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
...
Hello v-sshirivolu & MohdZaid_ ,
So, the final workaround that was suggested to me - update the source to PostgreSQL connector from the ODBC.
As of now 8 refreshes have been processed and 0 fails.
abhijit_mohanty Maybe the issue is due to Postgres and not in Power BI. Please check the below post
https://stackoverflow.com/questions/62807717/how-can-i-solve-postgresql-scram-authentication-problem
Thank you for the reply. My admin team is looking into this. Will keep you posted if this worked.