Forum Discussion
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 able to see only tables and I am not able see single view. Am I missing something ?
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
7 Replies
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.
HI ani_informa ,
Not able to understand your question.
What are you referring here as OBJECT and SINGLE VIEW?
Do add details to your query. Refer below article on how to get your question answered:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks,
Pragati
Thanks for your response !!
I am able to connect to Postgres database using ODBC but I am only able to see tables and I am NOT able to see views available under postgres db.
So what I did
1. Connect to Postgres database using ODBC option ( Get Data )
2. Under Navigator option, When I expanded Orders schema, I am able to see only tables and sql views were not visible. so in below snap account, contact, currency are tables
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
