(DESKTOP) Is it possible to insert new query without realoading data from previous queries?

[albersonmiranda]

I'm working with differents types of files that are generated monthly. For each type i intend to keep one only pbix file. So, in a file i'd have a query for 201801, 201802, 201803, (...). The problem is: each time i insert a new query to import a new file, Power BI reloads all files simultaneously all over again (and eventually crashes). How do i prevent that, or at least tell it to import one at time so it won't crash?

[ricardocamargos]

Hi @albersonmiranda,

I think these post can help you:

http://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up

https://stackoverflow.com/questions/42070677/what-do-enable-load-and-include-in-report-refresh-mean-...

[albersonmiranda · Accepted solution]

Nervermind. Just realized that only if i change the query on advanced editor it'll load all over again. Once your model is final, you don't need to.