Skip to main content

Power BI

Needs Votes

Associate queries to files using wildcards

Vote (8) Share
Nick Morris's profile image

Nick Morris on 20 Mar 2016 12:21:07

The folders function is great, but I want to have an association between filenames and queries using wildcards. For example, a folder has .log files from four different systems, each with a different format and transform. For Query A, use files based on the select Syslog*.txt, for Query B, select files that match B?????.log, or Query C select files ?????C???.csv

Comments (1)
Nick Morris's profile image Profile Picture

Craig Burton on 05 Jul 2020 23:28:14

RE: Associate queries to files using wildcards

Might be common ground with one I just posted: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35231557-apply-saved-m-query-to-file-with-particular-extens

Possibly applying a query by file extension is a special case of this request.