Gorilla Republic @gorillarepublic.co.uk · 18/06/2025E.g. Excel.CurrentWorkbook() followed by the named range. Can't recall the syntax. Or maybe I'm on the wrong track. #powerbi #excel #powerquery 110
Matthew Perren @matnav.co.uk · 18/06/2025That’s exactly it. I’ve got a wee button in excel that lets the user browse for the file. The cell it returns to is a named range “Path” That is then stored in PQ in a single value list called Path but Csv.Document(File.Contents(Path)) returns this error 100
Matthew Perren @matnav.co.uk · 18/06/2025Interestingly it’ll allow me to enter the path into a parameter and will take the contents of the parameter as a data source. But only if it’s entered directly into the parameter by the user. Not if the parameter is populated from a list query. 000
