Forum Discussion
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...
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
HI ani_informa
While connecting to the postgres, the ID you use(Probably yours).
Does it has access to query the view.
Views might be user created and you probably need permission granted to your ID to use it.
Hi Pranit
I can access views using the user in dbwear so I have access to views.
