Despite the wide variety of functions available in Power Query, sometimes it is necessary to define new custom functions for specific needs, especially in complex data cleansing processes. Such as ...

…where 2.129.181.0 is the version of the Power Query engine in my build of Power BI Desktop. This function was introduced for people developing Power Query custom connectors who only want to enable ...

Ever feel like creating custom columns in Power Query is more frustrating than it should be? The process can often feel overwhelming, especially when you’re juggling null values, complex calculations, ...

In my last post I showed how, in many cases, you can avoid the “dynamic data sources” error with OData data sources by taking advantage of query folding. That’s ...