Postgres connection using ODBC

[ani_informa]

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 ?

[Anonymous]

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.

[ani_informa]

Hi Pranit

I can access views using the user in dbwear so I have access to views.

[Pragati11]

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

[ani_informa]

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

[Pragati11 · Accepted solution]

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]

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]

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