Forum Discussion

fetterr's avatar
fetterr
Frequent Visitor
2 years ago

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 aroun...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

In PowerQuery, you can right click on the sources and turn off "Include in report refresh".

 

fetterr's avatar
fetterr
Frequent Visitor
2 years ago

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.