Power BI desktop & Teradata connection error

[abhijitd]

Hi, I'm trying to connect Power BI desktop with Teradata. I'm getting below error when trying to use direct query connection to import table metadata.

I get this error on every table.

 DataSource.Error: An error happened while reading data from the provider: 'Invalid column name.'
Details:
DataSourceKind=Teradata

[sivanagamahesh]

 Hi,

I get the accompanying mistake while getting to Teradata Database to "Get Data".

I have introduced the most recent PowerBI. Likewise introduced Teradata drivers includeing .NET information suppliers for Teradata. Nonetheless I contiue to I get the follwing blunder. I have attempted a wide range of un-introduce and re-introduce and clear the registries yet no good fortune. Indeed, even I attempted 32 bit form on my 64 bit portable workstation however no utilization. Would anyone be able to help on this?

"Teradata Database

this connector requires at least one extra parts to be introduced before it can be utilized. "

Thanks

[v-ljerr-msft]

Hi @abhijitd,

Could you try using Excel's Get & Transform (Power Query) experience to connect to a Teradata database to see if the same issue occurs?

In addition, make sure you're using the latest version of Power BI Desktop and .NET Data Provider for Teradata. 

Regards

[abhijitd · Accepted solution]

Hi,

This error went away when I moved from Windows 7 to Windows 10 machine.

Also performance of Power BI desktop seems to be much better on Windows 10.

Thank you,