Power Query what is faster for 2nd query ? Reference or source table from output of 1st query ?
I know that power query will refresh the first query on all referenced query.
Meaning, if you have a “main” query and then transformations in multiple query, the “main” will be refreshed every time. Slowing down your process.
Is it better to output the first query to a table and then use that as a source for the other queries ?
I know that power query will refresh the first query on all referenced query.Meaning, if you have a “main” query and then transformations in multiple query, the “main” will be refreshed every time. Slowing down your process. Is it better to output the first query to a table and then use that as a source for the other queries ? Read More