none
Empty trace files with PQ version 2.29.4217.1861 64-bit RRS feed

  • Question

  • I have turned tracing on for a workbook that takes a lot of time to refresh, hoping to leverage Chris's method to gain some insight on the causes of this poor performance. 

    I open the workbook, turn tracing on in Diagnostic options, hit the refresh all button. Data is correctly refreshed, but at the end, the trace files in the trace folder are all empty. !!?

    I am using PQ version 2.29.4217.1861 64-bit. Am I missing something or is it  a bug ?

    Best regards,


    Friday, March 11, 2016 10:55 AM

Answers

  • The problem was finally solved by renaming the "TracingLevel" registry key. It was then recreated by PQ with the correct value. Result below:


    [HKEY_CURRENT_USER\Software\Microsoft\Microsoft Power Query for Excel]
    "TracingEnabled"=dword:00000000
    "EnableCustomerExperienceProgram"=dword:00000000
    "TracingLevelOld"=dword:00000010
    "TracingLevel"=dword:0000000f
    Wednesday, August 24, 2016 4:07 PM

All replies

  • Might be a bug, current version is 2.32.4307.522 64-bit (February 2016), I would try upgrading to that and then see if the problem still exists.
    Friday, March 11, 2016 4:42 PM
  • Hi Bertrand. Do the trace files remain empty even after you close Excel?

    Ehren

    Friday, March 11, 2016 4:51 PM
    Owner
  • Yes. They remain empty after closing the application.
    Friday, March 11, 2016 5:35 PM
  • I downloaded my version from the Microsoft official page. It is indeed dated 2/23/2016. Even though the version number is different from the one you provided, it seems to be the latest one, at least available to me.
    Friday, March 11, 2016 5:38 PM
  • Apologize, I posted the version from Power BI Desktop, didn't read your post carefully enough.
    Friday, March 11, 2016 7:08 PM
  • Hi Bertrand,

    Any chance you have multiple instance of Excel running? Can you try closing all instances of Excel and see if it works?

    Thanks,

    Minh

    Monday, March 14, 2016 10:00 PM
  • No, only a single instance is running. But files are still empty at the end. Can anyone reproduce the issue ? 

    Tuesday, March 15, 2016 8:45 AM
  • Hi Betrand,

    After closing all instances of Excel, can you check task manager to see if there is any rogue excel.exe process running and end it? Does it resolve the issue?

    In some case when Excel crash, the application window disappear but the process is still running which may cause Power Query to hang on to the traces in memory instead of writing to text file.

    Thanks,

    Minh

    Wednesday, March 16, 2016 11:38 PM
  • The problem was finally solved by renaming the "TracingLevel" registry key. It was then recreated by PQ with the correct value. Result below:


    [HKEY_CURRENT_USER\Software\Microsoft\Microsoft Power Query for Excel]
    "TracingEnabled"=dword:00000000
    "EnableCustomerExperienceProgram"=dword:00000000
    "TracingLevelOld"=dword:00000010
    "TracingLevel"=dword:0000000f
    Wednesday, August 24, 2016 4:07 PM