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 cannot be query-folded. The whole datasets has probably tens of thousands of rows, with only a few hundres rows (those /MA and /MB) are required. It is not efficient to pull the entire dataset into Power BI and before filtering.
Is there any alternative I can use?
2 Replies
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-connectorThanks AlexisOlson It does not fold with one Text.Contains function. I guess transformation like Text.Contains cannot be fold with SAP BW.
I am not familiar with MDX, so I hope to find a solution using M query,
