Forum Discussion
SAP BW App Server - Variable not passed back to Server
Hi Anonymous
Firstly, please update power bi desktop to the lastest version,
You could write queries in this statement.
Or apply query as below:
If problem is still here, please let me the version of your power bi desktop and sap bw, type of the "Load_Date sufte", so that i will reproduce this on my side and find the solution.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your answer, v-juanli-msft
I tried to have a suitable MDX code but it's a bit of a problem, because I don't need Measures to be shown, just dimensions. Actually the desired outcome is a flat table with all SAP Dispute Manager cases with their respective attributes like "Load Date", "Case ID" etc.
Anyway, the the information you reuested is the following:
Additional info: we are loading data from queries which are based on SAP Composit Providers.
And the format of the load date field is "DATS 8".
And I'm using Power BI June 2020 Version.
Thanks a lot in advance!