Blog posts about Power query
Get username function in Power Query with few lines of M code. For the moment, there is no native way to get the Windows username in M language. The username might be useful to filter a table or to get a file path in the ‘Documents’ folder. The following post describes 4 ways to get…
Sometimes, it is useful to compare the same data from two columns. So, here is a simple function to do it in Power Query. The columns may be in the same table or in different tables. It provides data profiling in a very simple way. How to compare the same data from two columns in…
Often, we need to look for a table or for a specific column in the database. Do you know it’s possible to create a simple query to visualize your database schema within Power Query ? Very few steps for great results. How to display database schema (first method with data preview) Add a blank 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…
Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add a refresh date in a visual. How to add a refresh date to your report Create a table using ‘Home/Enter data’ menu and name it as you want. Add a…
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…
