suggestion -- 'caching' file contents? RRS feed

  • General discussion

  • I can see one of the cool parts of Power Query is its functional aspect -- it won't just randomly recalculate something if it knows the result will be the same.

    I noticed this doesn't hold for the file-reading functions like File.Contents() and Excel.Workbook() though. It seems these do get loaded on every function call (each time you change an unrelated part of the query) rather than at every change.

    I would think that from a file's 'last changed' timestamp attribute Power Query could technically know that a file would not really require reloading since the last time it was loaded (presuming this is remembered just like other results). Would this perhaps be a doable improvement?

    Tuesday, July 22, 2014 4:04 PM

All replies

  • It's doable, of course, but for a variety of reasons it's not easy. It's also applicable to only a small set of the data sources we support, which makes it a less attractive feature to implement.
    Wednesday, July 23, 2014 3:01 PM