Forum Discussion
Help 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...
Thats great and should I expect a big increase in speed?
Yes, 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.
I took out the extra T and the ge bit as didnt look right 🙂
Getting an error on this step?