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.

luisDamyller's avatar
luisDamyller
Frequent Visitor
6 years ago

any solution to this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    luisDamyller : 
    no, this seemed to be related to the BW connector. Data was showing correctly in the source, but after loading if would cut the string at 60 chars. So as mentioned in above post we split the field on BW side into chunks of 60 and then I concatonated them in Power BI. 

     

    So no real solution, just a workaround 😉