Export-PowerQuery

1.0.2

This function exports Power Queries' M-Code Formulae from an Excel PowerQuery Enabled Workbook to a specified
destination source code folder. This allows for the M-Code to be version controlled and maintained in a
source code repository alongside the rest of the workbook's source code (VBA, XML, SQL, DAX, etc.).

The function is designed to be used in conjunction with
This function exports Power Queries' M-Code Formulae from an Excel PowerQuery Enabled Workbook to a specified
destination source code folder. This allows for the M-Code to be version controlled and maintained in a
source code repository alongside the rest of the workbook's source code (VBA, XML, SQL, DAX, etc.).

The function is designed to be used in conjunction with the Import-PowerQueries function, which imports all of
the Power Queries' M-Code Formulae from the specified source code folder into the Excel PowerQuery Enabled Workbook.

Show more

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name Export-PowerQuery

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

Jimmy Briggs | 2023

Package Details

Author(s)

  • Jimmy Briggs

Tags

Excel PowerQuery M-Code Export Utility Mashup Formula Automation VersionControl Extract

Dependencies

This script has no dependencies.

Release Notes

1.0.2: Fixed Link to Project in Metadata
1.0.1: Updated to use DataMashup PowerShell Module
1.0.0: Initial Release

FileList

Version History

Version Downloads Last updated
1.0.2 (current version) 24 3/13/2023
1.0.1 5 3/13/2023
1.0.0 9 1/26/2023