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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.