I have a process that opens an excel file then uses Refresh Excel Data Connection to refresh all the data sources. Refresh Excel Data Connection works in regular mode. But in PIP mode, the activity got skipped. Is this a defect in PIP? Could this issue be addressed?
My power query report usually takes close to one hour to refresh and I could see the process skipped Refresh Excel Data Connection step and went ahead to refresh Pivot Table steps. And the whole process only took a couple minutes to finish. I also checked the underlying data after the process finishes successfully and the data is not updated. This only happens in PIP mode.