Forum Discussion
TLani1745
Jan 31, 2024Copper Contributor
Power Query from external data pulling into Excel not updating
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?
Eniola-Adekoya1
Jan 31, 2024Copper Contributor
Is the power query connector a folder on your desktop?
- TLani1745Jan 31, 2024Copper ContributorIt is located in a shared drive in my organizations network file folder.
- Eniola-Adekoya1Jan 31, 2024Copper Contributor
Can you go through this if it could help
https://support.microsoft.com/en-gb/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440#:~:text=In%20the%20Workbook%20Queries%20pane,Home%20%3E%20Query%20%3E%20Refresh%20preview.
- TLani1745Feb 01, 2024Copper Contributor
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!