Can not see all Table/views in AWS Postgres Connection

[cabibler]

IF I connect to the same data base via ODBC  It will show all the schemas as folders and then the tables/views within them.

IF I connect to the database via Postgres Connction.  only lists SOME of the items in a Schema.Table/view format.

However for the items I can't see  if I do a New Data Connect  and in Advanced, enter a SQL statement to Select  * from that view table  I can not see... I can get the Data to Load/Transform

It would be nice to see the full list of items I have access to in the Postgres connection.  I have seen other say Permissions in the database, but since I can pull via Select and also See them in ODBC connction  would this be the case here?

[v-menakakota]

Hi @cabibler ,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[lbendlin]

Do you have more than 1000 items in that enumeration?  

Does it work if you manually code the schema and table name?

Are you using the same login for ODBC and native?

[cabibler]

Do you have more than 1000 items in that enumeration?   if you mean do we have more that 1000 table views?? I would say no.

Does it work if you manually code the schema and table name?

if we go into Postgres data connection and use a Select statement.. we can pull the table/view.  We just have to know what the schema is.  It just doesn't pull up on a complete list of all the tables and views available that I can check the ones I want.

Are you using the same login for ODBC and native?

Only thing different between ODBC and Postgres are the Power BI Data connections.  Both are hitting the same database.

[v-menakakota]

Hi @cabibler ,

Thank you @lbendlin  for the information. Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

[lbendlin · Accepted solution]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .