Skip to content

Latest commit

 

History

History
30 lines (22 loc) · 1.54 KB

README.md

File metadata and controls

30 lines (22 loc) · 1.54 KB
Raw

Power Query Automations

Introduction

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.

Prerequisites

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.

Repository Structure

  • /Scripts - Contains all Power Query scripts.
  • /Examples - Example data files and usage examples for the scripts.
  • /Docs - Documentation for understanding and extending the scripts.

Usage

To use the scripts in this repository:

  1. Clone the Repository: Clone this repository to your local machine or download the scripts individually.
  2. Open Your Microsoft Application: Open your data project in either Microsoft Excel or Power BI Desktop.
  3. Import Scripts: Load the .pq script files into your project through the Advanced Editor in Power Query Editor.
  4. Configure Parameters: Adjust the parameters in each script according to your data source and specific needs.
  5. Refresh Data: Execute the queries to transform your data accordingly.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Support

If you encounter any problems or have queries about the scripts, please raise an issue in the repository.