This repository contains a collection of Power Query (M language) scripts designed to automate data importation, transformation, and processing tasks. These scripts are optimized for versatility across various data sources and structures, making it easier to handle tasks ranging from simple data cleaning to complex data integration.
Before you can use these Power Query scripts, you need:
- Microsoft Excel or Power BI Desktop.
- Basic understanding of the M language and data transformation concepts.
- /Scripts - Contains all Power Query scripts.
- /Examples - Example data files and usage examples for the scripts.
- /Docs - Documentation for understanding and extending the scripts.
To use the scripts in this repository:
- Clone the Repository: Clone this repository to your local machine or download the scripts individually.
- Open Your Microsoft Application: Open your data project in either Microsoft Excel or Power BI Desktop.
- Import Scripts: Load the .pq script files into your project through the Advanced Editor in Power Query Editor.
- Configure Parameters: Adjust the parameters in each script according to your data source and specific needs.
- Refresh Data: Execute the queries to transform your data accordingly.
This project is licensed under the MIT License - see the LICENSE file for details.
If you encounter any problems or have queries about the scripts, please raise an issue in the repository.