Forum Discussion

vrocca's avatar
vrocca
Advocate IV
8 years ago
Solved

Configure Gateway to connect to PostgreSQL

I'm running into an error when trying to create a new data source on my data gateway:     Cannot connect to the mashup data source. See error details for more information.   PostgreSQL: We were ...
Need Help
  • vrocca's avatar
    vrocca
    8 years ago

    2 Things to get this to work:

     

    1. Install the Npgsql provider on the server that's hosting the data gateway (https://www.nuget.org/packages/Npgsql/4.0.2)

    2. Reboot the server

     

    Should now be able to use the PostgreSQL data source type when creating the data source in Power BI Service.

  • Anonymous's avatar
    Anonymous
    8 years ago

    vrocca,

    As your post, you would need to install Npgsql provider on the gateway machine and make sure that you have access to the postgreSQL data source on the gateway machine.

    You can treat Power BI gateway as another client like Power BI Desktop. When using Power BI Desktop to connect to postgreSQL, Npgsql provider should be installed on the Desktop machine, so does the gateway.

    Regards,
    Lydia

vrocca's avatar
vrocca
Advocate IV
8 years ago

2 Things to get this to work:

 

1. Install the Npgsql provider on the server that's hosting the data gateway (https://www.nuget.org/packages/Npgsql/4.0.2)

2. Reboot the server

 

Should now be able to use the PostgreSQL data source type when creating the data source in Power BI Service.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    vrocca,

    As your post, you would need to install Npgsql provider on the gateway machine and make sure that you have access to the postgreSQL data source on the gateway machine.

    You can treat Power BI gateway as another client like Power BI Desktop. When using Power BI Desktop to connect to postgreSQL, Npgsql provider should be installed on the Desktop machine, so does the gateway.

    Regards,
    Lydia