Forum Discussion
mike_asplin
Helper V
Helper VHelp using SQl to limit the data being pulled form Microsoft Dynamics by Odata
I current have a model that is pulling whole tables of data form Microsoft Dynamics anbd then doing al lthe filtering in Power query. Is therer a way to do the filtering at source like you woudl wit...
mike_asplinHelper V
Helper VThats great and should I expect a big increase in speed?
Cookistador
Super User
Super UserYes, I encountered a similar issue with a customer. It used to take a few minutes for the change to take effect, but now it only takes a few seconds.
The idea is to filter your data before importing it.
If you do not see an improvement, please post again and we will see how we can improve it.