Power Query to Excel Table will not consistently refresh

[rdjmaddress]

Have several worksheets using power query to refresh data from a .csv file in a share on the same subnet as the workstation.  

Issue is that I can close all spreadsheets and reopen the one I want to refresh the data in and it will refresh, but, only one time.  

The data is generated in a .csv file and is 100% refreshed, meaning no append only all new data in the .csv file.   I would seem as if power query has "cached or stuck" source file information that it doesent want to access the file directly from excel.  

The folder where the files are stored is added as a trusted location, (sorry no domain services).  And windows explorer and ftp and both access the new content that the excel doesnt seem to be accessing.  

Have tried messing with all the auto refresh settings and none seem to make this any different.  

What is it that I am not finding that could be the cause of this issue? 

[rdjmaddress]

This simply will not work until i close and re open all instances of Excel.  That is a software short fall.  Not sure what the solotion is.  

[rdjmaddress]

This simply will not work until i close and re open all instances of Excel.  That is a software short fall.  Not sure what the solotion is.  

[rdjmaddress]

Follow up to this, I would be curious to find out how many users are not getting updated data because they don't know that this is occurring?  

[rdjmaddress]

So this is still not solved. if the file is not the only or first Excel spreadsheet opened then the refresh fails.  sometimes the fisrt open will work and sometimes it won't.  appears to be no reason for it to fail other than other open instance of excel with Power Query in use.  

Still frustrated by the lack of consistent funtionality of this seemingly hepful module.  

[rdjmaddress]

Update, 

Can definitely confirm that it is a collision of two open instance of excel configured to access the files in the same folder that causes the refresh to not work.  Makes no sense.  

Can anyone suggest why this might occur?  

[rdjmaddress]

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.  

[Anonymous]

Hi @rdjmaddress ,

Were these .csv files saved before refreshing? Please try saving the workbook before refreshing. PowerQuery does not refresh unsaved change data.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[rdjmaddress]

so, nothing i have tried will make this work as intended.   I can open the saved file with no issue as a csv directly in excel and it is updated on the server.  Excel/Powerquery will not updated the data in the file.  This should be simple as i am not appending the data simply pulling new data of the entire contents of the file. 

I really hate the way developers think and code regarding these "utilities".  Seems like no one thinks this thread is a legitimate issue.  Or everone has seen the behaviour and doesnt want to say it just wont do what i want.

[rdjmaddress]

A question about this, Is Power Query checking file date and time before refreshing the data?