Forum Discussion
Getting Error When SAP ByDesign Integrating with Power BI Using CData Connector
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 ...
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
1 Reply
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