Forum Discussion
Can not see all Table/views in AWS Postgres Connection
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?
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 .
5 Replies
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?
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.
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 .
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.
