PostgreSQL refresh doesnt work from Power BI enterprise gateway.

[Hupos]

We are having trouble with data refresh of PostgreSQL database from enterprise PowerBI gateway, but direct connection and refresh from PowerBI desktop works well. Every scheduled refresh we get these errors in enterprise gateway logs:

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
Reason= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): The key didn't match any rows in the table.

So far we have tried to update the gateway and also the PowerBI desktop, Postgre SQL data source connects flawlessly in gateway configuration, but refresh doesnt work for us.

I would appreciate any help with this issue because the log isnt clear to me.

Thank you

[v-yuezhe-msft · Accepted solution]

@Hupos,

In your scenario, please check that if your account that used to connect to PostgreSQL database has sufficient permissions on the tables you imported into Power BI.

If there is no issue with permission, please delete the data source under gateway and re-connect the data source, make sure connection strings of the data source under gateway are same as that in Power BI Desktop.

Regards,
Lydia

[Hupos]

Hi,

setting up proper permissiones for all tables solved the problem

Thank you.

Hupos