Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

CMD Prompt Popping Up During Changes

Hi all,

I’m seeing recently a recurring issue in Power BI Desktop where a brief CMD window appears during report load and sometimes during semantic model-related changes. After digging into it, I found that the CMD window is actually SQLDUMPER.EXE.

From what I understand, SQLDUMPER.EXE is a Microsoft diagnostic utility that gets triggered when an internal Microsoft component crashes or throws an exception. In this case, the actions seem to be tied to msmdsrv.exe, which is the backend model/query engine used by Power BI Desktop.

What the issue looks like

  • The black CMD window appears briefly.

  • It first happens while the report is opening, specifically during “Preparing report”.

  • It can also happen later when making changes that affect the semantic model, for example renaming a field or making other model-related modifications.

  • The issue does not seem to be a simple visual/UI problem. It looks more like the backend model engine is hitting an exception and SQLDUMPER is collecting a dump.

My troubleshooting so far

  1. Confirmed the CMD window is SQLDUMPER.EXE
    Using process monitoring, I confirmed that the CMD window is SQLDUMPER.EXE. Looking deeper, the process triggering it appears to be msmdsrv.exe, which is the Analysis Services/model engine running behind Power BI Desktop.

  2. No issue with a PBIX that has no external file connection
    In my tests, the issue does not appear when the PBIX contains only embedded data and no external data source connection to a file. You can simulate it just entering a dummy data using "Enter Data" in power bi. Issue will not happen on those reports.

  3. Happens in both Store version and downloaded version
    I tested both:

    • the Microsoft Store/App version

    • the downloaded installer version

    The issue happens in both.

  4. Preview features do not seem to be the root cause
    Turning off some preview features, such as On-object interaction, seemed to reduce the frequency somewhat, possibly because they trigger semantic model changes more often.
    However, this did not solve the issue completely, so I do not think this is purely a preview feature problem.

  5. Cache clearing and fresh install did not fix it
    I tried:

    • clearing cache

    • fresh installation

    • switching to the downloaded version

    None of these resolved the problem.

  6. Running Power BI as Administrator prevents the issue
    While investigating logs, I noticed some apparent file access-related problems involving msmdsrv.exe. That led me to try Run as administrator.
    When I ran Power BI Desktop as Administrator, the issue did not appear.
    I even turned all preview features back on and tested again as Administrator, and it still did not happen.

  7. Moving the PBIX to a simple local folder did not help
    I also moved the report to a simple folder path such as: C:\test. This did not solve the issue.

Current conclusion

So far, on my machine, the only thing that prevents the issue is running Power BI Desktop as Administrator, which is obviously not a real solution.

At this point, I suspect this may be one of the following:

  • a Power BI Desktop bug

  • a permissions / file access / credential issue

  • something related to external data source connections

  • possibly some interaction between the local Analysis Services engine (msmdsrv.exe) and file-based external sources

Main questions

  • Is anyone else seeing SQLDUMPER.exe appear during “Preparing report” or during semantic model changes?

  • Has anyone identified the exact trigger?

  • Has Microsoft acknowledged this anywhere?

  • Is there any proper fix besides running Power BI as Administrator?

Thanks in advance. I’m sharing this in case it helps others narrow down the issue.

powerbi snapshot.jpg

Status: New
Comments
Mike-B
New Member
Hello, I have noticed the command window popping up and changing my window focus over the past week or so. Thanks to your post, I checked and see that it is SqlDumper.exe for me as well. I tried updating to the latest version of PBI Desktop and still have the issue. It happens when I open the report, change a datatype or decimal place, etc. in the table view, and during some changes to visuals and measures, etc. After a little research, I enabled tracing to see if that would help identify the issue. So far, I have seen messages like these: Exception Message: An existing connection was forcibly closed by the remote host Exception:Microsoft.AnalysisServices.XmlaStreamException ---> Microsoft.AnalysisServices.XmlaStreamException ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. Exception: ExceptionType: System.IO.EndOfStreamException I thought it might be related to my larger model that pulls data from multiple dataflows. I created a new report and pulled in one table from the sample data and it still has the issue. I hope we can find a resolution to this issue soon.
burakdemirtas
Advocate II

Hi Mike, I also hope to have a solution asap for this. It is super annoying in the development and a lot of my colleagues having the same issue.

During my investigation so far, it doesn't appear on 2 cases:

1-When it's opened in the "run as administrator" mode.
2-When you use the "RS" (Report server) version.

If you have the possibility, you can give it a try for one of these options. (even if this is not a real solution)

Mike-B
New Member
Sorry, I don't have permissions on my work computer to try either of these. I will let you know if I come across any other cases that appear to avoid the issue.
dmkblesser
Advocate II
I'm also experiencing the same issue, and unfortunately, I don't have the admin access to try the workaround. I'm on the March version of Power BI desktop.
burakdemirtas
Advocate II
This is a super annoying bug. Really slowing down my development. I don't know why only a few people are complaining about it.
dmkblesser
Advocate II
I brought this up to the Microsoft support. Provided them with the trace logs. Hopefully they can find something from there. 100% agree, super annoying!
mwha
New Member
This started for me about a week ago - only change that I'm aware of around that same time was the addition of Co-Pilot premium. Power BI Reports now take twice as long to open, and will sometimes completely fail to open and just sits on a white screen, playing a blocked action sound anytime you click anywhere until you kill it in the task manager. C:\Program Files\WindowsApps\Microsoft.MicrosoftPowerBIDesktop_2.152.1279.0_x64__8wekyb3d8bbwe\bin\\SQLDUMPER.EXE
Matthew_Martell
Helper I
This is happening to developers at our workplace too. We don't have access to 'run as administrator' though. 🙁 Power BI version is 2.152.882.0 (March 2026)
dmkblesser
Advocate II
I tested this in a previous version Version: 2.150.2455.0 64-bit (January, 2026) and cannot reproduce the issue. A problem introduced by the newer version.