topic Re: Issue to Create Dataset API for on premise in Developer

Issue to Create Dataset API for on premise

Vrushali — Tue, 08 May 2018 09:58:13 GMT

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

Re: Issue to Create Dataset API for on premise

v-micsh-msft — Wed, 09 May 2018 08:45:05 GMT

For on-premise Data Source, you need to use the gateway.

And PostgresSQL is listed as the supported data source for User configured manual or scheduled refresh:

More information, see:

On-premises data gateway

For the detailed steps, follow:

Power BI Connectivity to PostgreSQL

Regards,

Michael

Re: Issue to Create Dataset API for on premise

Vrushali — Wed, 09 May 2018 12:37:32 GMT

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

}
]
}