Forum Discussion

HDRA's avatar
HDRA
Regular Visitor
1 year ago
Solved

Power Query Issue in Power BI: Unable to Cancel Refresh

Hi everyone, I'm having a problem with Power Query in Power BI only, I can't cancel a current refresh using the “Cancel Refresh” button in the “Refresh Preview” button drop-down list it is greyed. C...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hi HDRA,

    We regret the inconvenience caused and acknowledge your requirements. Please consider raising a Microsoft support ticket for further investigation. You can explain all the troubleshooting steps you have taken to help them better understand the issue.

    You can create a Microsoft support ticket with the help of the link below:
    https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

    If this helps, please accept it as a solution and drop a "Kudos" so other members can find it more easily.

    Thank you.

freginier's avatar
freginier
Solution Sage
1 year ago

Hwy there!

 

Here are some possible causes:
- Power BI is not detecting an active refresh.
- The refresh is stuck due to a slow or large dataset.
- The query contains complex transformations that prevent cancellation.

 

Try stopping the refresh manually: Go to Power Query Editor.
- Click on File → Close & Discard.
- If Power BI asks you to confirm, click "Yes".
- Reopen Power BI and try applying changes again.

 

If Power BI is completely stuck, force stop the application:

- Press Ctrl + Shift + Esc to open Task Manager.
- Find "Microsoft Power BI Desktop".
- Right-click → End Task.
- Restart Power BI and try again.

 

Disable Background Data Loading

- Go to File → Options & Settings → Options.
- Under Global → Data Load, disable: "Allow data preview to download in the background."
- Click OK, restart Power BI, and try refreshing again.

 

Check for Stuck Queries, Open Power Query Editor.
- Check if a query is stuck on "Loading".
- If a query is frozen, delete that query and retry.

 

Hopefully one of these solutions helps you!

😁😁

HDRA's avatar
HDRA
Regular Visitor
1 year ago

Hi ! 
Thank you for replying, I tried it all but doesn't work for me. I think that I'm using heavy querries as Omid_Motamedise said. 
I'll try to optimise it and will let you know. 

Thank you !

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    1 year ago

    Hello HDRA,

    Could you please confirm if your query have been resolved by the solution provided by Omid_Motamedise? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

     

    • HDRA's avatar
      HDRA
      Regular Visitor
      1 year ago

      Hello,

       

      I've tried the solution provided by Omid_Motamedise , but it didn't work. 

      I can't stop the refresh even if it's a very simple and small query.

       

      So I still have the issue... :s