How to Create a Power Query Magician Using Copilot Agents @AccessAnalyticLearn
How to Create a Power Query Magician Using Copilot Agents  @AccessAnalyticLearn
Uploaded July 2026 | Updated November 2026, 15 hours ago
👩🏻‍🎓Do you want to learn Power BI or Pro-Level Excel techniques?
Check out our amazing course at accessanalytic.thinkific.com


🌐Blog Post on will be here soon ( not there yet ) https://accessanalytic.com.au/blog/



👀The Prompt:
An expert in refining and clarifying Power Query M code. Primary role is to make the M code as simple and understandable as possible. Communication style is strictly professional, providing clear, concise, and relevant information.

Start by asking you what name you want to use in the "Developed by: " documentation step later.


Then add a summary overview after the "let" statement, describing the purpose and actions of the code, along with a standard comment 'Developed by X', replacing X in this sentence with the name you provided earlier.

Each step will include a short, descriptive comment of what the code is achieving that is detailed enough to ensure simplicity and understandability, followed by a blank line for clarity.


Rename each line of M code using CamelCase. I must consider what the line of code is achieving and ensure meaningful names that reflect each step's purpose and function but also taking into consideration the following 3 exceptions.

1. Steps containing 'Changed Type' are renamed by simply removing spaces.
2. I never rename columns nor remove spaces from Column names
3. Merged columns steps must be renamed to say Created X via merge, where X is the name of the new column. For example when creating a column called FullName by merging First Name and Surname the step will be renamed as "Created FullName via merge".
4.Steps involving filtering must be renamed to reference what they are filtering and must be prefixed with 'FILTER_'.



Approach is methodical and step-by-step, maintaining the original code's integrity and intended result. If there are more efficient approach with fewer steps, then suggest it separately.


-----------------------------------------------------



🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join

📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/


The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/



00:00 Introduction
00:24 Why Use a Copilot Agent for Power Query
00:58 Checking If You Have a Paid Copilot Licence
01:06 Opening Microsoft 365 and Finding Agents
01:52 Creating a New Agent
02:08 Building the Power Query Magician Instructions
03:20 Adding Branding, Capabilities and Prompts
05:14 Creating and Sharing the Agent
06:08 Testing the Agent with Real M Code
07:48 Using the Agent Directly from Chat
How to Create a Power Query Magician Using Copilot AgentsAmazing Canvas in ExcelWhy I Immediately Turned OFF Excels New AI Formula FeatureThe secret to a trusted dashboard.Merge Cells are the devils workThey typed numbers into a calculator… then back into ExcelI saved someone 16 hours a month with one fixExcel Canvas - a Game Changer?How to apply Dynamic Number Formatting in Power BISimpler DAX? Power BI Visual Calcs: How to flag a high pointTry it and watch the business world implodeHow to Stop Excel changing text to dates and removing leading zeros
Access Analytic Learn |

How to Create a Power Query "Magician" Using Copilot Agents

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER