Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hello!
I am trying to develop my own external tool to perform certain calculations from a dataset, however I am lost to where to begin. Most of the documents and articles I have found online are instructions of writing the JSON file to connect the scripts to Power BI desktop. I would like to know how I would begin developing the script. Is there a template I could follow, or base code to develop on? I am not sure what functions/commands I would need to be able to retreive information from the datasets onto Powershell.
Any tips, articles or documentation on how to write the script for the external tool would be of great help.
Thank you!
@HarrisonOVT
If you want to create custom connector here is the tutorial. If not, what kind of external tools do you mean.
Start developing custom connectors for Power Query | Microsoft Docs
Paul Zheng _ Community Support Team
Are you planning to run your own DAX queries? MDX queries? Something else?
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 51 | |
| 41 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 135 | |
| 110 | |
| 50 | |
| 31 | |
| 29 |