Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I am encountering an issue with a PPU dataset where the dataset is locked for modifications/processing. I have attempted to cancel the session but it appears to not work. Anyone have any suggestions on what to try?
Cancel command run:
<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<SessionID>9BC583E5-A426-48EF-BE3E-BB31C8DFAC56</SessionID>
</Cancel>
Thank you in advance.
What you will need to do is to first find the SPID with the following MDX Query
SELECT
session_spid
, session_user_name
, session_last_command
, session_current_database
, session_cpu_time_ms
, session_elapsed_time_ms
, session_start_time
, session_last_command_start_time
, session_last_command_end_time
FROM $system.discover_sessions
WHERE session_status = 1
ORDER BY session_start_time desc
And then kill it using the above SPID with this XMLA Query
<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<SPID>5622</SPID>
</Cancel>
Thanks for the suggestion @GilbertQ . I have tried the cancel command in many iterations (using SessionID, SPID, adding CancelAssociated true/false) and it does not kill the session. Just got of a call with Microsoft support and they seemed stumped. They are looking into with their various teams.
It has certainly worked for me in the past.
Also if you are using a Gateway just restart the Gateway service, that will kill the session if there is any data still going through
Yes it has worked for me as well ini the past. If I execute a refresh I see the new session come up and that one I can cancel. But it just waits for the original session to finish (it's been hanging there for 2 days now) and it never does so our refresh times out after 5 hours. Data source is cloud based so no gateway being used. Thanks again for your insight/suggestions.
User | Count |
---|---|
48 | |
28 | |
21 | |
19 | |
19 |
User | Count |
---|---|
51 | |
47 | |
25 | |
23 | |
20 |