Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Power Query from external data pulling into Excel not updating

Copper Contributor

Hello,

 

I have an Excel Power Pivot that was already created. I have refreshed the query to pull in FY24 data. The query updates, but the FY24 data does not pull in. Can you please assist me?

6 Replies
Is the power query connector a folder on your desktop?
It is located in a shared drive in my organizations network file folder.

@Eniola1814 

 

Hi. I performed those steps, but with no success. I did find a coworker to help me and we resolved the issue. Thank you for your help!

@TLani1745 

Can you provide your fix? I am having the exact same issues  affecting almost 100 users

I went into Advanced Editor to write in an additional step.