Forum Discussion
Excel Source Files - Trying to refresh from local files on a different machine
Hi All,
Amongst our team, we've shared a PowerBI desktop file, where the source data is excel. These excel files were local to one person's machine.
Now as we pass the PBI desktop file around, it continually tries to refresh this data and throws an error once the file cannot be found. Is there a way to mark these files as static (they won't need refreshed ever) so that the "pending changes" error doesn't pop up every other click?
3 Replies
- jdbuchanan71
Super User
In PowerQuery, you can right click on the sources and turn off "Include in report refresh".
I see that option available, but still no luck when marking it. I've tried to upload additional files and they all are blocked because of the ones I've already maked as "dont include in refresh" are in error.
I've had the original owner mark them all as "dont include in refresh" and send me an updated copy, but when I recieve it it still wants to try and refresh them from the source.
- jdbuchanan71
Is the data still in the tables though? You may have to move the files to a network location that you can all access.
