Forum Discussion
SAP BW Query folding - filter by text
I am pulling some data from SAP BW andtry to achieve query folding as possible as I could. I try to filter a column (Work Operation Center) by string that contains "/MA" and "/MB" but this step c...
It seems like it should be able to handle that. Will it fold if you have just one Text.Contains function (remove the second one)?
If you can't get it to fold, then one possibility is to connect using a query string. I don't know much about SAP BW, but this documentation suggests to me that it's possible to use an MDX statement for a query string.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-bw-connector