Multiple power queries from the same data source

  • Hi


    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?



    Code
    1. Private Sub Worksheet_Change(ByVal Target As Range)
    2. ThisWorkbook.RefreshAll
    3. End Sub



    Thanks,


    Jurate