Forum Discussion

PPPPP's avatar
PPPPP
New Member
6 years ago
Solved

Postgresql gateway failure on website

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

The installed database provider 'Npgsql' targets an incompatible .NET Framework. Please install Npgsql version 4.0.10.0 or earlier.

 

I can conect PostgreSQL on PowerBI Desktop with direct query but when i publish dashboard to website,I found error that i shown above. how to fix it?.

 

For your information : 

I install Npgsql-4.1.3 , .Net Framework and config On-premises data gateway (standard mode) already. And  My database have to connect VPN 

Need Help
Tips and Tricks
Tutorial Requests
  • ibarrau's avatar
    ibarrau
    6 years ago

    Hi. Have you configure the data source in the Power Bi Service under Manage Gateway? It looks like the connection between them isn't ok. Check manage gateway and look at the source to check if it was a green check.

    Regards

  • andrew_796's avatar
    andrew_796
    6 years ago

    I get the same error message for SQL Server. Same problem. I can update via the desktop but once publishing the web service, it fails. The Gateway I use to update the data, says "Online: You are good to go", yet I cannot refresh the data through the Web Service. 

4 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    6 years ago

    Hi. Have you configure the data source in the Power Bi Service under Manage Gateway? It looks like the connection between them isn't ok. Check manage gateway and look at the source to check if it was a green check.

    Regards

    • andrew_796's avatar
      andrew_796
      Icon for Helper I rankHelper I
      6 years ago

      I do have all green check marks for my gateway and the gateway I use is up to date. 

  • andrew_796's avatar
    andrew_796
    Icon for Helper I rankHelper I
    6 years ago

    I get the same error message for SQL Server. Same problem. I can update via the desktop but once publishing the web service, it fails. The Gateway I use to update the data, says "Online: You are good to go", yet I cannot refresh the data through the Web Service. 

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi PPPPP ,

     

    You may follow the steps below:

     

    1.Ctrl + Alt + Del to open the Task Manager

    2.Click the "Services" tab

    3.Find "On-premise data gateway service" in the list

    4.Right click and click "Start"

    Or you may upgrade the gateway to latest version, ad try it again.

     

    Reference:

     

    https://lytix.be/having-power-bi-on-sap-bw-using-a-gateway/

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.