Data Profiling views in Power Query (Excel and Power BI)
By identifying problems before they become errors Data profiling views in power query helps to ensure your data is clean & ready to be loaded into a model
Tag: powerquery tips
How to Reconcile Accounts using Power Query
Learn how to create a template that you can re-uses to reconcile accounts using Power Query for Excel or Power bi
How to Parse Custom JSON Data using Excel
To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format. Excel is a powerful tool that allows you to connect to JSON data and read it. However sometimes this data might require a little manipulation to be fully understood and analysed in Excel. In this article you […]