Forum Discussion
Issue loading text strings longer than 60 characters from SAP BW
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.
We are experiencing the same issue
It was previously commented by MS prod engineers it is SAP issue, but I disagree. Long text data displayed properly in all SAP applications, but truncated loading to Power BI through the connector.
If an Excel contains long text but truncated when loading into Power BI, I can't blame Excel
If an SQL Server display long text correctly but truncated when loading into Power BI, I can't blame SQL
Please take the ownership of the issue, work with SAP and fix the issue
Thanks,
Rick
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.