Agentic Power Query Development
Let an LLM write, run, and self-correct Power Query M on its own using PQTest, without ever touching your PBIX, dataflow, or semantic model.
Power Query¶
Sometimes It's Good to Fail: Raising Errors with Data Quality Tests
Having your dataflows or semantic models fail to refresh can be frustrating, but at least you know that whatever caused the error did not make it into your...
Custom M Function #7: fxReplaceWithDefaultValue
Click here to go straight to the function.
Custom M Function #6: fxSplitCamelCaseColumns
Click here to go straight to the function.
Custom M Function #5: fxCumulativeToIncremental
Click here to go straight to the function.
Power Query Level Up: Exploring the Advanced Editor and the M Language
Recently, I had the privilege of delivering my first public training session at the 2024 Global Power Platform Bootcamp where I gave an introduction to the...
Custom M Function #4: fxSetColumnTypesFromModel
Click here to go straight to the function.
Custom M Function #3: fxSplitCamelCaseText
Click here to go straight to the function.
Custom M Function #2: fxGenerateSurrogateKeyColumn
Click here to go straight to the function.
Custom M Function #1: fxJoinAndExpandTable
Click here to go straight to the function.
