Data Flow connect to on-premise Teradata Source

RGI · ‎12-12-2018

I can successfully connect to various data sources to create a data flow.

When I attempt to connect to Teradata I get the following message:

The evaluation could not be finished: Evaluation was cancelled, message: (Session ID: 44fcee91-d9d2-44b5-b1c1-443f061e6a0e)

The Teradata server is on-premise and I'm using my on-prem gateway. The same gateway is used to access various databases (e.g. MSSQL and Teradata) without a problem. So as far as I know the gateway is fine.

It's when I attempt to connect to the Teradata source via my gateway when building a data flow that I run into problems.

Can it be done?

Any ideas?

jeffshieldsdev · ‎01-23-2019

I was hopeful when I saw the January update announcement for Dataflows (especially since the Teradata connector is specifically called out), however this error still persists.

I can't even connect trying to use a blank query:

I've selected my gateway and entered credentials but it just keeps popping back to "please specify how to connect".

jeffshieldsdev · ‎01-11-2019

Same issue for me.

Anonymous · ‎12-12-2018

Hi @RGI,

How did you create dataflow entity query? Can you please share more about these?
BTW, current dataflow seems not support custom functions and advanced operations in queries.

Regards,

XIaoxin Sheng

RGI · ‎12-13-2018

These are the steps I take:

Choose the workspace

Click Create

Click Dataflow

Click Add New Entities

Click Teradata database

Enter server, gateway and authentication details

Click Next

Anonymous · ‎12-18-2018

HI @RGI,

Did this issue only appears on teradata datasource? Have you use same authorization mode and corresponded credentials on it?

In addition, you can also try to store this datasource as CDS-A entity, then get data from that entity if it works.

Regards,

Xiaoxin Sheng

RGI · ‎12-18-2018

We only have a problem with Teradata (on-premise). MSSQL (on-premise) data sources are fine. We can connect to several MSSQL servers through the gateway, but not to Teradata.

Credentials are correct. We've checked and double-checked several times.

We have not tried CDS-A. I wanted to keep it simple - if possible doing everything via the PowerBI framework.

Initially I just want to know if this is a bug, and if so when/if it will be fixed.

Anonymous · ‎12-21-2018

HI @RGI,

I try to search for similar issue on Internet and find one similar issue. It seems like operation timeout so power bi cancel to create data flow entities.

Can you please refer to GilbertQ's suggestion to reduce your data amount and try again?

Dataflows - Evaluation was canceled

Regards,

Xiaoxin Sheng

RGI · ‎12-21-2018

Hi Xiaoxin

The problem is I'm not getting that far - I am not able to perform an initial "connection" to Teradata in order to choose a database followed by table/view.