Hi,
Im a newbie and not sure if my query takes so long due to source data being slow (ODBC Sage connector) or If Im doing something wrong?
Originally I had all my queries loading onto tabs, however I have changed this now so source queries (apologies for wrong terminology...I mean initial queries I have merged into main query) are just connections. Should this have speeded up the loading of my Merged query.......the fact there only now connections feeding into my main query?...or does it not necessarily work like that.
I have a 2nd query returning to excel and then do a vlookup ref 2nd query to main. Would it be faster to do this in power query and only have this second query as a connection?
Highlighted yellow = subquerys
Glass Pivot (main query)
SAS (2nd query lookup source)
Many Thanks
Gareth
Im a newbie and not sure if my query takes so long due to source data being slow (ODBC Sage connector) or If Im doing something wrong?
Originally I had all my queries loading onto tabs, however I have changed this now so source queries (apologies for wrong terminology...I mean initial queries I have merged into main query) are just connections. Should this have speeded up the loading of my Merged query.......the fact there only now connections feeding into my main query?...or does it not necessarily work like that.
I have a 2nd query returning to excel and then do a vlookup ref 2nd query to main. Would it be faster to do this in power query and only have this second query as a connection?
Highlighted yellow = subquerys
Glass Pivot (main query)
SAS (2nd query lookup source)
Many Thanks
Gareth