We are connecting PowerBI to SAW BW, and are facing an issue on many queries where the query parameter does not show up for selection in PowerBI. Example query is below – where you can see that in B...
The traces do not contain any calls to retrieve members for the 0P_AP_LEDGER variable. The release version of PowerBI only supports getting values for Characteristic variables.
For further investigation, could you please execute the following BAPI using transaction SE37 and send us the output?
BAPI: BAPI_MDPROVIDER_GET_VARIABLES
With:
CAT_NAM = '0FIAP_M30'
CUBE_NAM = '0FIAP_M30/Z0FIAP_M30_AGE_Q0001_2'
Best Regards,
Herbert