Performance comparison between DirectQuery & DataImport

Hello @akiko_lim,

Checking the Power Query Timings can be done using Monkeytools add-in from www.excelguru.ca.

There are some detailed explanation in the documentation here
This is a small sample

There is also a thread on the forum for it here : Thread: Monkey Tools

Hope this helps.

1 Like