I am working on a report, made by someone I cannot reach anymore. I would like to know the logic behind this setup..
There are (very large) datatables connected with SQL.
In Power Query he has divided different queries into folders/sections:
In each 'stage' are some basic steps, like changing a column name and type and merging with lookup tables.
Could it be that he needed to make some adjustments first on two tables and then merge them to the other?
If so, is this the best approach?
It takes about 20 to 30 minutes to refresh the dataset. Does it take this long because of this setup?
I hope someone can enlighten me 🙂