Connect Teradata Stored Procedure to Power BI

[engageuser]

Hello, I am new to Power BI.

I have a stored procedure in Teradata and I want it to connect to Power BI.

My idea is to have a search bar in Power BI which allows user to seach an ID. Once the id is being searched, it will run a stored query from Teradata like the below:

Select

id,

t_id,

datetime,

conversations_transcripts

from

database.conversations

where id in ('insert_id');

I have searched a few resourrce online and the solution revolves around connecting power bi with SQL server stored procedure. I cannot use SQL server since the data I need is stored in Teradata.

Anyone has experience  with this?

[v-xinc-msft]

Thank you for rohit1991‘s fantastic reply!

Hi @engageuser ,

You could also refer to the Power Query Teradata database connector - Power Query | Microsoft Learn for detailed connection steps and supported features.

Another useful resource is a guide on How to Integrate Teradata Into Power BI - Zebra BI.

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[engageuser]

Hello I don't have an issue connecting teradata with power BI, but I am more looking into having a stored procedure in Power BI while the data sits in Teradata. 

[v-xinc-msft]

Hi @engageuser ,

Thank you for your kind reply.

Did you try the actions in rohit1991 's reply? DirectQuery mode allows you to query the data in your Teradata database directly without importing the data into Power BI.This approach allows you to execute stored procedures in Teradata and display the results directly in Power BI.

Did it help you in any way?

Best regards,

Lucy Chen

[rohit1991]

Hi @engageuser ,

To connect a Teradata stored procedure to Power BI and enable dynamic filtering via a search bar, you need to use DirectQuery mode with a parameterized query. Since Power BI does not support direct execution of Teradata stored procedures, an alternative approach is to use Native Queries in Power Query (M language) combined with a Power BI parameter.

First, connect Power BI to Teradata via the ODBC connector, then create a Power Query parameter to capture the user input from a slicer or search box. Use this parameter inside a custom SQL query in Power Query, ensuring that the query dynamically updates based on the user’s input. Since DirectQuery mode is required for real-time queries, enable "Bind Parameters" in the Teradata ODBC settings to improve performance.

Additionally, for seamless execution, consider using a stored table where Power BI retrieves results instead of calling the stored procedure directly. If real-time execution is critical, a workaround involves Power Automate or REST API calls to trigger the stored procedure externally and refresh the Power BI dataset. This ensures that users can dynamically filter Teradata data within Power BI without needing SQL Server.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.
Connect with me on LinkedIn: Rohit Kumar