Forum Discussion
Postgres connection using ODBC
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 ,
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
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
