Prevent refresh of certain data ranges, queries, something RRS feed

  • Question

  • I have build reports in Power Query that retrieve 13k+ processed rows for source data, it takes a couple of minutes for that data to be generated, delivered, and rendered into Power Query.

    What I'd like to know is if there's a way to flag that data as immutable, constant, cacheable, or something like that, so that it doesn't need to be retrieved again. It's historical data that doesn't change. I use it for long-term trending, so I want to have all that data in the report, but there literally is no reason to re-retrieve that data every time I want to update with an incremental smidgen of new data.

    Is there a way to make the report faster/more efficient to run, to not re-download all that historical data again?

    Thank you

    Monday, June 5, 2017 11:18 PM


All replies