Changing Power Query Source

[cmcreynolds]

I'm facing a couple of issues as I'm trying to share an Excel document with colleagues. I used PowerQuery to grab data from a workbook in OneDrive and whenever my colleague tries to refresh data, it says the path is unavailable - but I noticed it is using the C:\\ from my machine. My colleagues have viewing privileges to the document on OneDrive, but they still can't refresh.

SO, how can I change the source within PowerQuery so she can refresh the data? I guess WITHOUT using the OneDrive path?

 

[ImkeF]

See if this could help: Share and Refresh Power Query with Local Links - PowerPivotPro