Dax Studio is constantly disconnecting

Hi danielpitz,

I hope you are doing well today ☺️❤️

So there is too many reasons for this caused issue:

First One: (most common)

If you are working locally against Power BI Desktop the embedded instance will shut down after a few minutes of inactivity (DAX Studio then loses its connection and you have to reconnect or refresh metadata)

To Fix this you need to:

• Go to File  > Options  > Advanced

• Check Keep connection alive

• Set an interval like 120–240 seconds
  

  • This prevents the idle timeout from kicking in

• For remote servers (Azure Analysis Services  (AAS), Power BI Premium XMLA endpoints) a keep alive also guards against network timeouts (proxies or load balancers or VPNs)

Second Reason: Connection timeout settings is too short

DAX Studio ships with default timeouts that might be too aggressive for slow models or networks so to fix this and prevent it from giving up:

• File > Options > Advanced

• Increase Server timeout (from default 600 to 1800 seconds or even 0 for unlimited)

• Increase Connection timeout (like a 60 seconds)

Third Reason: Aggressive metadata refreshes

You said that you are spending time refreshing metadata So If metadata is set to refresh automatically on every model change a schema change can sometimes trigger a disconnect or reconnect cycle and to Fix this you need to 

• Switch metadata to manual refresh

Final Reason: Network instability (remote connections)

If you connect to a remote XMLA endpoint anything that resets the TCP connection (VPN drop or Wi‑Fi flicker or proxy timeouts) will break DAX Studio

• Run a long EVALUATE {1} query in a loop using a separate tool (or SSMS) to see if disconnects happen there too

• If your company uses a proxy ensure localhost and the XMLA endpoint are excluded

   

Last Tip:

• Open the same model in SQL Server Management Studio (SSMS) or Tabular Editor and see if you experience similar disconnects If yes the issue is on the server or Desktop side (or network)

• If no its a DAX Studio specific setting or bug in this case capture the log and you can share it us and see if we can solve this.

   

Hi danielpitz  ,

Thank you for reaching out to Microsoft Fabric Community Forum.

Microsoft updates and releases Power BI Desktop monthly, and only the latest version of Power BI Desktop is supported. If you experience issues with Power BI Desktop, please ensure you are using the latest available version.

Power BI semantic model behavior depends on the storage mode. Import mode semantic models require data refresh to update imported data. DirectQuery semantic models do not import data; instead, they query the underlying data source when users interact with reports or visuals.

For DirectQuery models, the performance and response time depend on the underlying data source because queries are sent to that source during report interactions.

Regarding external tools, Power BI Desktop supports external tools that are installed locally and registered with Power BI Desktop. When launched from the External Tools ribbon, Power BI Desktop passes connection information to allow the tool to connect to the model. External tools are provided by third-party contributors, and Microsoft does not provide support or documentation for those tools except for the underlying public Microsoft APIs.

Documentation:

Power BI Desktop latest release and support:
https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update

Power BI semantic model storage modes (Import / DirectQuery):
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

DirectQuery guidance:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

External tools in Power BI Desktop:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-external-tools

Thanks Ahmed-Elfeel for Addressing the issue.

Hi danielpitz    ,
we would like to follow up to see if the solution provided by the user resolved your issue. Please let us know if you need any further assistance.

Thanks

Hi @danielpitz    ,
we would like to follow up to see if the solution provided by the user resolved your issue. Please let us know if you need any further assistance.

Thanks.

My problem has not been solved. Should I send a log file if/when it happens again?

Hi danielpitz ,

We're sorry to hear that your issue is still not resolved. Please find the support ticket link below. This will help the support team investigate the issue further.

Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

Thanks,

Chaithanya.

A few things worth trying before you dig into the log file (which support is right to ask for, but these often fix it without needing that):

1. Elevation mismatch - this is the most common cause of this exact symptom. If Power BI Desktop is running elevated (as admin) and DAX Studio isn't, or vice versa, Windows won't let the local Analysis Services connection stay open and you'll get constant reconnect prompts. Make sure both applications are running at the same elevation level (ideally neither running as admin, unless you have a specific reason to).

2. Antivirus/VPN/endpoint security - some endpoint protection tools inspect or kill local loopback TCP connections after a short idle period, which looks exactly like "constant disconnects". Try temporarily disabling any VPN/AV and see if the problem goes away; if so, add msmdsrv.exe (the local SSAS engine Power BI Desktop spins up) and DAX Studio to your exclusions list.

3. Windows power/efficiency throttling - if Power BI Desktop loses focus for a while, Windows can throttle it under "Efficiency Mode"/background app limits, which can suspend the local engine and drop your DAX Studio connection. In Task Manager, right-click the PBI Desktop process and make sure Efficiency Mode isn't being applied, and check Settings > Apps > Background apps.

4. Update DAX Studio - there have been several GitHub issues logged for frequent disconnects that got fixed in more recent releases, so if you're not on the latest version it's worth updating first.

If none of those help, it's worth going ahead and capturing that log file for support - with a live repro they'll be able to pinpoint whether it's the connection timing out, the model reloading, or something else entirely.

Hi danielpitz 

This "constant disconnecting" in DAX Studio is almost always due to 1 of these 3 reasons:

1. Elevation Mismatch - Most Common Fix
If Power BI Desktop is running as Admin and DAX Studio is NOT, or vice versa, Windows kills the local connection.

Fix: Close both.
Right click > Run both Power BI Desktop AND DAX Studio either both as Admin OR both NOT as Admin.
Best practice: Run both normally without Admin.

2. Antivirus / VPN killing local connection
Endpoint security tools kill the local loopback connection to msmdsrv.exe after few seconds of idle.

Fix: Temporarily disable AV/VPN and test.
If it works, add these 2 to AV exclusion:
1. msmdsrv.exe
2. DAXStudio.exe

3. Windows Efficiency Mode / Background Throttling
Windows suspends PBI Desktop when it's not in focus.

Fix: Task Manager > Details > Right click PowerBI.exe > Set Efficiency Mode OFF
Also: Settings > Apps > Background apps > Turn OFF "Let apps run in background" restrictions for Power BI

4. Update DAX Studio
There were bugs in older versions that caused frequent reconnects.
Download latest: https://daxstudio.org

Try point 1 first. That fixes it 80% of the time.

You don't need Admin mode for logging to work. But both apps must be at same elevation level.

Let me know which one worked!