Power Query to Excel Table will not consistently refresh

Short answer is always use the full explicit network path address rather than a mapped drive.  

I think have resolved this issue.  The .csv is created in a Unix server and saved on the server during the creation process, not opened.  This is not the issue.  

I looked at the file pathway that I "broswed to" to get the file.  Turns out that for what ever reason, using a mapped network drive location to access the Samba share does not work correctly or consistently in Power Query.   After testing several times and with multiple files open using the explicit network path with all folders listed out it works as expected.  

Example:

\\abc\tmp\filename.csv  "Mapped drive address"

vs.

\\abc\root\usr\tmp\filename.csv  "Full Network Path address"

This is frustrating because, Windows Explorer has no issue picking up the file in a window or from a windows shortcut, hand off to Excel and Power Query and no not going to ask windows to translate that when you use the browse button to select the file in a file browser window.  This is a huge miss for a package that is supposed to help save time and automate tasks.