Forum Discussion

danielpitz's avatar
danielpitz
Icon for Helper I rankHelper I
1 year ago
Solved

Numerous disconnects from Semantic Model

I've asked this before, but missed the response asking for a log file. My queries get disconnected frequently. It's getting to the point that it happens every 2 - 5 query runs. I would upload a log...
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi danielpitz ,

     

    If you are not seeing the "Start Tracing" option under the Advanced tab in DAX Studio, it's possible you are Using a version that has moved or renamed this option Or you are missing the Developer or Diagnostics features due to how it was installed.

    Please follow below steps.

    Step 1: Ensure You are Using the Latest Version. Download and install the latest version.

    If you’re using a version older than 3.x, the interface may be missing newer features like improved logging or integrated tracing.

    Step 2: Enable and Use Diagnostics Logging

    Option A: Use Built-in Tracing (New Versions)

    Open DAX Studio. Go to the Advanced tab. Look for "Start Tracing" or "Enable Tracing". we want diagnostic logs instead.

    If the button isn’t there, try using the menu: File > Options > Advanced and check for a logging setting.

    Option B: Manual Logging via Command Line

    If tracing doesn't appear, you can still collect logs manually:

    Go to File > Options. Enable “Debug Mode” or “Verbose Logging” under Advanced. After enabling, try rerunning your queries until the disconnection happens.

    Then go to this folder:

    %localappdata%\DaxStudio\Logs

    Note: You will find the latest .txt or .log files there.

    Step 3: Try This Stability Workaround

    Sometimes DAX Studio disconnects due to how it attaches to the Analysis Services process. Try the External Tools method:

    Open your .pbix file in Power BI Desktop. On the ribbon, go to External Tools. Click on DAX Studio from there. This launches DAX Studio attached directly to Power BI’s Analysis Services instance. This method reduces the risk of connection drops due to mismatches or background refreshes.

     

    If our response addressed, please mark it as "Accept as solution" and consider giving a "KUDOS". Feel free to reach out if you need further assistance.

     

    Regards,

    Dinesh

     

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi @danielpitz ,

Have you tried the verbose option?

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as "Accept as solution" and consider giving a "KUDOS". Feel free to reach out if you need further assistance.

 

Regards,

Dinesh

danielpitz's avatar
danielpitz
Icon for Helper I rankHelper I
1 year ago

I have it on verbose now, but of course it's mostly behaving more properly. I do have one log file from when it had a hard crash, as i call them, where I need to either use Task Manager or a dialog that pops up after a while to kill the program. I can give you that along with the time of the crash if it might help

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi danielpitz ,

    Thank you for your confirmation. As you mention that, Verbose is working fine. Till now no crash or  query disconnection not happen?. Let us know if you need any further assistance? If every thing is fine can  i close this thread?

     

    Thank you

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi danielpitz ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.In case we do not receive a response, we shall proceed to close this thread. For any further discussions or queries, please initiate a new thread in the Microsoft Fabric Community Forum, where we will be glad to assist you.

    Thank you.