Power Query with SAP Business Objects Universe swaps values in some columns

[JorgP]

Hello,

we are facing a problem with Power Query in connection with SAP Business Objects Universes.

The universes are working fine and without problems with other SAP BI Tools (e.g. Web-Intelligence, Explorer).

The issue occurs after connecting Power Query with the SAP BO Universe when choosing specific fields we selected for the report.

For some reasons the values for this particular measures are swapped with another measure. The headers and header sequence are correct displayed in the report but the values for measure 1 are displayed in the column for measure 2 and vice versa.

The mistake only occurs when we are taking 3 particular measures in the query design. All other combinations (e.g. only using 2 of the 3 measures) are handled correct by Power Query.

Has somebody an Idea what could be the cause of this behavior?

Kind regards

Jorg