Getting Error When SAP ByDesign Integrating with Power BI Using CData Connector

[LalithAlmeida]

Hi Experts ... 

Can anyone help on below issue

DataSource.Error: ODBC: ERROR [HY000] There are too many columns specified in projection and the query risks failing with [414] URI Too Long error. Please reduce the number of columns in projection or if your service does not have such restrictions, try increasing the allowed select length by setting the MaxSelectLength property to a higher value(Default 1000) or disabling the length limitation by setting it to -1.
Details:
DataSourceKind=CdataSapbydesign
DataSourcePath={"dsn":"CData Power BI SAPByDesign"}
OdbcErrors=[Table]

Best Regards ...

[Anonymous · Accepted solution]

HI @LalithAlmeida,

According to the error message, it seems like the response table include too many fields that exceed to the limit. I'd like to suggest you modifying the SAP queries to reduce these column amounts.

Creating and Executing a Query | SAP Help Portal

Regards,

Xiaoxin Sheng