Forum Discussion

ani_informa's avatar
ani_informa
Helper III
6 years ago
Solved

Postgres connection using ODBC

Hi   I have connected powerbi desktop to postgres database using ODBC and I am able to connect successfully however when I am expanding database in powerbi desktop and trying to add objects, I am a...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi ani_informa ,

     

    What you can do is, while you are connecting with your PostgreSQL DB, select your DSN.

    After that there is an "Advanced Options", expand it and write a query (SELECT * from VIEW;) to retrieve data from your view.

     

    Check if this resolves your issue.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi ani_informa ,

 

What you can do is, while you are connecting with your PostgreSQL DB, select your DSN.

After that there is an "Advanced Options", expand it and write a query (SELECT * from VIEW;) to retrieve data from your view.

 

Check if this resolves your issue.

 

Thanks,

Pragati

ani_informa's avatar
ani_informa
Helper III
6 years ago

Thanks but I have 5 to 10 views which I want to pull on power bi desktop side to create star schema and reports so I cannot use option of SQL

  • ani_informa's avatar
    ani_informa
    Helper III
    6 years ago

    I see option of writing custom SQL provided by Pragati also works for me so closing this discussion.