Forum Discussion
Solved
Use a named range in Excel for Power Query Data Source
My client needs txt files from a supplier converted to excel. I've created a PQ to do that but I'd like to make life easy for them so I've added some VBA which allows them to look up the file to b...
Hi everyone
A dirty solution would be to ignore the privacy levels.
The procedure is described here:
https://exceloffthegrid.com/formula-firewall-in-power-query/#AlwaysIgnore
To get the contents of a file as Source, you use:
File.Contents(full_pathname)
Of course, you also have to properly parse the file and depending on the file type, you might use Csv.Document, Json.Document, Xml.Document or some custom connector.