Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Power BI Teradata Gateway issue

I have setup .NET Connector for Teradata and added the data source but after report publish in Direct Query I'm receiving the following error

Shailin_0-1642537396945.png

 

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

1. Check if the on-premise data gateway installed on the same machine as Power BI desktop. If not, please make sure the machine has on-premise data gateway run can access Teradata database.

2. Double check the server name, database name, credential entered when you create the data source under gateway are the same as in Power BI desktop.

3. Update the on-premise data gateway to the latest version.

4. Downloaded the latest Teradata ODBC driver on the gateway server and for the authentication piece, use Windows credentials.

 

 

Best Regards,

Stephen Tao

 

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

 

 

View solution in original post

5 REPLIES 5
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

1. Check if the on-premise data gateway installed on the same machine as Power BI desktop. If not, please make sure the machine has on-premise data gateway run can access Teradata database.

2. Double check the server name, database name, credential entered when you create the data source under gateway are the same as in Power BI desktop.

3. Update the on-premise data gateway to the latest version.

4. Downloaded the latest Teradata ODBC driver on the gateway server and for the authentication piece, use Windows credentials.

 

 

Best Regards,

Stephen Tao

 

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

 

 

Anonymous
Not applicable

I have observed that the issue is only when the Power BI dataset is published in DQ model. If the dataset is import, the dataset is refreshing and I'm able to view the report

Anonymous
Not applicable

The Teradata data source is configured with basic authentication. Also SSO is disabled so it should work with the credentials. 

Also the connection get successfully created in the data source on service showing cunnection successful.

Not really what I asked. can all gateway cluster members access your Teradata data source independently? Ie can you log in remotely to all gateway cluster members and do a connectivity test from each of them?

lbendlin
Super User
Super User

can all gateway cluster members access your Teradata data source independently?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.