Then there’s version control-you’d like a mechanism to manipulate the mashups in files so that you can wire up a version control setup. If any of these possibilities perk your interest, Data Mashup Cmdlets may be a useful tool in your Power Query toolkit. To explore Power Query mashups and supporting details contained in a Microsoft Excel or Microsoft Power BI file using a GUI, check out Data Mashup Explorer.Learn about the file format used to store Power Queries in The Data Mashup Binary Stream: How Power Queries Are Stored.Use this module to compare Power Query expressions between two files and search Power Query expressions in multiple files.Use Visual Studio Code to edit Power Query saved in Power BI and Excel files.Using PowerShell Core 7+ on Windows, install from PowerShell Gallery: Currently, Data Mashup Cmdlets are in alpha.Update-Module DataMashup -AllowPrerelease #Data mashup install# In particular, the ability to modify content is experimental. Please make backup copies of files before you use these cmdlets to modify their contents. In particular, it is likely that the validation logic used to check new Power Query code will need refining.To empathize the inherit risk, any action that modifies a file requires that flag -Experimental be specified.
