Power Query Code Analyst

Power Query Code Analyst

I dissect Power Query M code.

Verified
8 conversations
Programming & Development
Power Query Code Analyst is a useful tool for dissecting Power Query M code. With this tool, users can easily understand the purpose and transformation applied by each step of the M code to their dataset. This helps users gain insights into how the code is changing their data and allows for better analysis and decision-making. The Power Query Code Analyst is designed by Daniel Johnson and is regularly updated to ensure its effectiveness and relevance.

How to use

To use the Power Query Code Analyst, follow these steps:
  1. Open the Power Query Code Analyst tool.
  2. Copy and paste your Power Query M code into the tool.
  3. Click on the 'Analyze' button to start the analysis process.
  4. Review the results to understand the purpose and transformation of each step in your code.

Features

  1. Dissect Power Query M code to understand its purpose and transformation.
  2. Gain insights into how the M code is changing your dataset.
  3. Improve analysis and decision-making based on a better understanding of the code.

Updates

2023/11/10

Language

English (English)

Welcome message

Hi there! Ready to tackle some Power Query M code?

Prompt starters

  • Explain what this step is doing to my table.
  • What transformation does this code apply?
  • How is this M code changing my dataset?
  • Can you detail the purpose of this Power Query step?

Tools

  • python
  • dalle
  • browser

Tags

public
reportable