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 editor
  • Copy this code and close advanced editor
let
    Source = #shared,
    #"Converted to Table" = Record.ToTable(Source),
    #"Sorted Rows" = Table.Sort(#"Converted to Table",{{"Name", Order.Ascending}})
in
    #"Sorted Rows"
M functions documentation : functions list

Then, you get a list of M functions and constants. Click on a function to get details (don’t click on the word ‘Function’)

M functions documentation : example

You get many information including description, parameters, examples, …

M functions documentation : filters

Of course, you can filter the names just like you do with any other table

Don’t forget to remove filter before applying a new one because they are cumulative !

So, in this way, you always have M functions documentation available no matter if you have an internet connection.

See how to get documentation about your data model : Visualize your SQL database schema within Power Query

Custom analyser

Custom analyser

With ‘Custom analyser’ feature, Power BI Sidetools users can use external tools built by the…

Read More

Leave a Reply

Your email address will not be published. Required fields are marked *