Power Query

AdoDotNetQuery

M functions documentation within Power Query

Often we look for the documentation of a function or we even look for a function. We may use Microsoft documentation (https://docs.microsoft.com/fr-fr/power-query/). But there is an other way much more comfortable for my needs: access to M functions documentation within Power Query How to Add a blank query and name it ‘Shared’ Open the advanced …

M functions documentation within Power Query Read More »

Duplicates detection in Power Query using different methods

As duplicates are a nightmare in databases, I wrote a function to identify them between two tables. Duplicates detection in Power Query is extremely useful for data consistency. Additionally, it helps to avoid relationships isues. You may also use the same function with only one table. The function is optionally insensitive to case, separators and …

Duplicates detection in Power Query using different methods Read More »