Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Issue loading text strings longer than 60 characters from SAP BW

Using SAP BW implementation 2.0 connector, anyone else having issue loading text longer than 60 characters from SAP BW? We are running BW 7.5 and in the HANA database, column is defined as CHAR with...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    We had a ticket open for Microsoft regarding this and they studied the issue "with the help of SAP team" for a while. Ticket was solved 2019-09-25.

    The conclusion at that time was that as Power BI uses BEx Queries to connect to BW (as do other 3rd party tools, but most SAP tools use different access method), there is a limitation with the character limit and there is no workaround as the limitation is in the MDX technology.

    They referred to this kb article https://apps.support.sap.com/sap/support/knowledge/public/en/2096749
    and that the same limitation applies to Power BI. BW version did not make a difference.

     

    So at the time, solution would have been to split the data or get it from Hana directly.

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous 

 

To get faster and better technical support for this issue, you may directly create a support ticket.

stayup_artist's avatar
stayup_artist
Frequent Visitor
6 years ago

thank you, but we have done that and the prod engineers came back saying "this is an SAP issue and bye"