-
Notifications
You must be signed in to change notification settings - Fork 2
Home
Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources. It is available in several Microsoft products, including Excel and Power BI. Power Query provides a powerful and intuitive interface for data transformation and preparation.
- Microsoft Power Query Overview
- Power Query M Language Specification
- Power Query in Excel
- The Power Query UI
This library contains a collection of useful Power Query functions that can help you with various data transformation tasks. Below are some articles that provided the basis for functions in this library:
- Chris Webb's Article on Removing HTML Tags
- Ken Puls's Article on Dynamic SQL Queries with Power Query
- Paper on Simulating Color Blindness
To get started with the PQ-Shared-Library, you can clone the repository and explore the available functions. Each function is documented with examples to help you understand how to use them effectively.
You can also use the SharedMaster.pq file for a table with all of the functions. One add that in as a new query, you can invoke each query, give it a name, and use it.