How to Configure CData ODBC Drive for SAP ByDesign to connect Power Bi?

[former_member816053]

I configure step by step

1. Choose CData SAP ByDesign Source & Click Add.....

2. Fill Data URL, User, Password

3. Analytics Service ( As you can see in Figure 3, I took the link from SAP Analytics Connection) Do we use that link for the ODBC Analytics Service?

4. Fill Data Source Name (Is it data source from SAP ByDesign or we can be given according to our own preferences?)

5. Click Test Connection

6. Shows error

Please give me any suggestion

[may_thitsaoo · Accepted solution]

Hello Wai Yan,

Fill Anaytics Service : ana_businessanalytics_analytics.svc.

And try again Test Connection.

Regards,

May

[former_member816053 · Accepted solution]

It's working. Thanks Ma May Thitsa Oo.

But we can't retrieve SAP Bydesign tables from Power BI ODBC. It shows

DataSource.Error: ODBC: ERROR [HY000] Unable to retrieve columns for table [Account Financial Data].

Details:

DataSourceKind=Odbc

DataSourcePath=dsn=CData SAPByDesign Source

OdbcErrors=[Table]

Is it wrong to connect Power Bi? If you have step by step pdf or link, Please kindly share.