Data Truncating

[amandabus21]

Hello, 

Im having some of the data in one of my columns truncating.

The full length seems well under the Power BI limit so not sure why this is happening. 

Anyone have any ideas?

Power BI: 

SAP BW:

[metrica]

Hi @amandabus21 

This appears to be a truncation issue related to the SAP BW BEx/MDX access path, not a general Power BI text-length limit.

If the same data can be exposed through an SAP OData service, you may want to try Power BI Connector for SAP:

https://www.sap.com/products/data-cloud/partners/metrica-software-inc-power-bi-connector-for-sap.htm...

It uses SAP OData services instead of the BEx/MDX path, so it may avoid this issue if the OData service returns the full text value. The connector supports large datasets, scheduled refresh, and incremental refresh. A 30-day free trial is available.

Documentation: https://metricasoftware.com/docs/sap/

Support: https://metricasoftware.com/docs/sap/contact-support-sap/

We can also arrange a demo and help verify compatibility with your SAP environment.

Cheers,
Metrica Team

[MasonMA · Accepted solution]

@amandabus21 

Hi, this happens to Power BI when it connects to SAP BW. My colleagues asked me same question lately.

I'd suggest you refer to this post. Solved: Issue loading text strings longer than 60 characte... - Microsoft Fabric Community

I even followed up just a few weeks ago but no one responded. 

[amandabus21]

Seems like a long standing issue then, thank you for sharing the information!