Power Bi Odbc - How Select Schema

Good afternoon,

We use odbc connector to access our Teradata (we use the TTU 15) and we are looking for a simple solution allowing to select the SCHEMA directly from the ODBC connection when doing a "GET DATA" from Power BI Desktop.

Why ? Because people who are using PBI does not have SQL knowledge and it takes more than 1 minutes to display the database's liste.

We know it's possible to do that from the SQL query but we are looking for a solution to do that in the connection itself.

We've tried using the DATABASE/DB/SCHEMA but no way, each time Power BI Desktop display us the entire list of database.

Any idea or tricks ?

3
David Miller

David Miller

Executive Financial & Market Analyst

David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.

Share this article