Create Custom Execution Log in Power Query RRS feed

  • Question

  • I have a several complex Power Queries in my Excel file that load data dynamically based on Parameter table in the spreadsheet

    The Power Queries are working fine. However I want to have some way to log the Execution Steps for the queries

    e.g. If query loads data from 2 files in the folder then it should log the names of the files that were imported.

    I was looking at Diagnostics Trace however the information on this function is very limited

    Is there any way to create Custom logs in Power Query

    Tuesday, November 21, 2017 5:43 AM


All replies

  • I would very much like to see how this can be done as well!

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Wednesday, November 22, 2017 4:59 PM
  • Hi swatiabhyankar. Currently there's no easy way to do this. However, having a simple way to get this kind of insight into your queries sounds like a great feature request. :)


    Thursday, December 14, 2017 9:07 PM