Forum Discussion
Anonymous
6 years agoNot applicable
M-code for getting only required data with bex as source
Hi , Im trying to import data using Bex as source however prior importing would like to filter out the data which is not relevant and consider only what is meaningful...We do have default prompt...
- Anonymous6 years ago
I wouldn't write m-code unless you have to. From power query, just click the column header and apply a text filter.
Anonymous
6 years agoNot applicable
Hi Anonymous
Thanks for your brief explanation helpmed me alot.
Can you suggest a way to filter data via power query( should i go with writing M-code) ? shall i go with Query Parameters any advice?
Regards,
Husna
Anonymous
6 years agoNot applicable
I wouldn't write m-code unless you have to. From power query, just click the column header and apply a text filter.
- Anonymous6 years agoNot applicable
Anonymous
Thank you for your prompt response and very clear explanation....Atleast got to know which is the better option .
Regards,
Husna