CODEWITHSUNDEEP
powerquerypowerpivot
Mahmoud
Mahmoud

Reputation: 5

Refresh power query before power pivot

I have power query collect data from external file , then some process done and load to data model where i made many power pivot from them I made final report form , this report send to employee where they only see on sheet report , just extract source file and press refresh all.text the problem is when I extract new source file some pivot table filters disappear , so I have to manually reset them

enter image description here

enter image description here

I think that the problem data added to data model before query finish , so some column filter doesn't exist , i need to delay refresh power pivot after power query

Upvotes: 0

Views: 449

Answers (1)

teylyn
teylyn

Reputation: 35915

In the Power Query properties, untick the box that enables background refresh.

With background refresh, PQ will start the refresh and the PivotTable will refresh before the PQ refresh is finished.

Disable background refersh, so that the PivotTable refresh only starts after the PQ refresh has completed.

enter image description here

Upvotes: 1

Related Questions