This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
I had a hard transformation to make.
Pandas was too slow.
Polars looked faster.
I wanted the machine to do the work.
The built-in copilot could not carry the load.
Too small. Too careful.
No frontier models. No long leash.
I could use the Pi harness to write the code.
That part was easy.
The hard part came after.
The notebook failed.
I read the errors.
I fixed the code.
I ran it again.
After a while, I became the bottleneck.
So I asked a simple question:
Is there a better way?
There was no clean way to expose Fabric notebooks to an external coding agent.
At least not officially.
But there was VS Code.
There was the Fabric CLI.
There was Livy.
There was the SQL analytics endpoint.
That felt like enough.
So I built around them.
The CLI edits the notebooks.
The CLI runs them too.
Livy works as well, though it fights you on lakehouse writes.
I added a custom Python tool.
Clanker generated it.
It catches cell-level execution and errors.
The harness reads the errors.
Tries again.
Runs again.
Repeats until the notebook executes cleanly.
Then the SQL endpoint checks the transformed data.
After that, I define test cases.
The harness keeps iterating until every test passes.
Closed loop.
The code is here: Link
It works for me.
If you find sharper edges, smoother paths, or stranger failures, change it.
Commit your edge cases.
Let the next person suffer less.
Hi @goreavin ,
Thanks for sharing this and contributing to the community.
Really appreciate the effort you put into documenting it. This will be helpful for others working on similar scenarios.
If you ever need assistance or have further questions, feel free to reach out or raise a new thread.
Keep engaging with the Fabric Community.
Best Regards,
Vinay.
Check out the April 2026 Fabric update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 6 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 29 | |
| 16 | |
| 12 | |
| 10 | |
| 7 |