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