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 ...

This Custom Data Connector wraps many of the "Get" endpoints in the Power BI API (with the exception of the /executeQueries endpoint), so that OAuth can be used to authenticate to the service. This ...

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 ...

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, ...

Learn to fix Power Query date format errors and missing columns efficiently using the new culture record argument in ...