Refreshing ThisWorkBookDataModel vs. Power Query querires

[cr731]

If I have 5 Power Query queries that load to the data model, within the Data > Connections window, I see a list of each query as well as ThisWorkBookDataModel.

I am writing a macro to refresh all the queries in my file and wondering if I need to refresh all the PQ queries AND ThisWorkBookDataModel - is it redundant to refresh both / what is the difference?

I don't want to use RefreshAll because I want to loop through specific queries to refresh.

Thanks

 

[Matt Allington]

If you refresh the queries individually in order, then there is nothing else to do. I am not even sure what happens when you refresh ThisWorkbookDataModel. Maybe it is the same as going to PowerPivot and clicking refresh all - not sure. But I do know for sure if you manually refresh each query, then you are done.