Forum Discussion

Hupos's avatar
Hupos
New Member
8 years ago
Solved

PostgreSQL refresh doesnt work from Power BI enterprise gateway.

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...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Hupos
New Member
8 years ago

Hi,

setting up proper permissiones for all tables solved the problem

Thank you.

Hupos