I added a PostgreSQL connection successfully using an On-Prem Data Gateway. When I try to add the connection to a new app, it gives me only one choice for a dataset which is labeled `default`.
When I click on `default` it moves to the `Choose a Table` panel and then brings up the following error very quickly (no processing time at all):
Since the PostgreSQL connector is in Preview this is probably just the default error (which happens to be Excel).
PGAdmin finds many tables (none of which I have access to) and many views for which I do have access to query.
Can I pass in a query and skip the table selection step like in PowerPivot?
I have NPGSQL installed as well as an ODBC Driver.

Report
All responses (
Answers (