Forum Discussion

Vrushali's avatar
Vrushali
Frequent Visitor
8 years ago

Issue to Create Dataset API for on premise

I am trying to create dataset (API) using postgres


"connectionString":"Data Source=postgresql://localhost/Postgres?user=other&password=secret;Initial Catalog=Postgres;Cube=Model"


And m getting 202 response in postman but in PowerBi desktop getting issue
"This Data source can not be accessed by data gateway server:"postgresql://localhost/Postgres?user=other&password=secret;"

 

Any other way to do this .

 

Thanks In advance

Need Help

2 Replies

    • Vrushali's avatar
      Vrushali
      Frequent Visitor
      8 years ago

      Thank you for ypu reply :)

      Just want to clarify I am able to connect to Power Bi desktop via gate way on premise .

      Here I am facing issue while trying through power BI API

       

      {
      "name":"postgres",
      "defaultMode":"AsOnPrem",
      "tables": [],
      "datasources":[
      {
      "name":"postgres",
      "connectionString":"Data Source=postgresql://localhost/Postgres?user=other&password=secret;Initial Catalog=Postgres;Cube=Model"
      OR
      Data Source=jdbc:postgresql://localhost/Postgres?user=fred&password=secret&ssl=true

      }
      ]
      }