Skip to main content

Power BI

New

Apply saved M query to file with particular extension

Vote (2) Share
Craig Burton's profile image

Craig Burton on 28 Aug 2018 20:35:30

We've a need to import (zipped) XML files with a particular format. Whilst we can import the XML files, we're having to wire in the path into the M query. Ideally we'd like to be able to associate a particular query with a file extension and have Power BI either offer that as another data source type or just apply the query automatically when the user selects a file with that extension.

Key part is the user should be able to select the file (as per CSV, etc), rather than opening a file as XML then having to go through the M querying again, or wiring in the path to a particular file.

Many thanks!

Comments (1)
Craig Burton's profile image Profile Picture

bb4445f3 64eb-43ad-ad0e-03b6a7bc9306 on 05 Jul 2020 23:28:14

RE: Apply saved M query to file with particular extension

Probably related to https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13046805-associate-queries-to-files-using-wildcards