I have created three power queries to have a different view of the same information, but for whatever reason, any new data entered in either of the Amazon tabs gets only updated in one power query which I have created last - please see attached file.
I am new to the power queries and not sure if it's possible to have multiple power queries from the same data source? I would be grateful if you could review my power queries and let me know what might have caused this issue.
Also, not sure if this should go on a separate thread, but I have researched that if you have the below VBA code in the data source tabs, power queries should automatically update themselves, but I find that it is very slow. Any thoughts on how to make the refreshing faster?