PowerQuery Text File Extraction - Set to Ask for File name on Refresh?

[dls0406]

Disclaimer - I am a new user.

I have created a powerquery that pulls in a text file and performs several formatting steps before close&load to an excel file. The problem is, that each month, I need to change the text file that is being pulled into the powerquery. (The file is emailed to me from an external source). Now, I know I can manually edit the query source and select a new source each month. However, I was wondering if it was possible to have excel ask for a new file each time I hit "refresh"?


I see that if I use legacy text import, I can do this, but I dont see an option when I use regular text import. And if I use the legacy text import, then I cant seem to figure out how to make the formatting changes within the same query. Any Ideas?

 

[sandy666]

maybe try From Folder option
in this folder replace old text file with new then refresh query

 

[dls0406]

I guess there is no way to re-promt each time? I am not the exclusive user of these files and the locations where they are saved, so it would make more sense from my standpoint if I did not have to create new folders. Though if thats the only way it may be a use-able work-around

 

[sandy666]

create ONE folder where you put text file
in the SAME folder replace old text file with new

you need only re-create your query to this option: Data-New Query-From File-From Folder once
then after change text file in this folder - refresh query (every time if text file will be changed)

 

[dls0406]

Yes I understood what you meant, which may be a decent workaround if it is impossible to do what I had hoped. Thanks for your help!

 

[sandy666]

You are welcome
Have a nice day

 

[collin8579]

I had a similar issue,, check out this > Changing Query Source with VBA Help: Excel file on network path
I have the file name in the workbook itself and the query pulls from that path/name listed