Unable to add ODBC data source to standard gateway.

[Anandhu12]

Hi Community,

I have configured a standard gateway for odbc driver, which load data from SAP datasphere.but, when I try to add the odbc data source into the gateway cluster , an error is generated.The odbc driver works fine in Power BI desktop and I was able load data there.

So why I can't insert the datasource into the gateway cluster?

Attaching the screenshots for reference

                              Figure 1

                                 Figure 2

                             Figure 3

[meenakp]

Hey,

I am novice in Datasphere. But let me still ask a question. Isn't Datasphere a cloud solution? So why such datasource needs to be added to Gateway? (For example - Sharepoint sources need not pass through gateway).

I see you had chosen Datasource type as "on-premise" also.

Regards

[Pradeep2]

are you creating the gateway on the same server as you are with BI Desktop ?