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 ...
Need Help
  • 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

    }
    ]
    }