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 project was initiated based on a task found on Upwork. The task involved consolidating several TSV files into a single file. Each file required transformation and merging before being merged to ...

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

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