Forum Discussion
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.
Can anyone help me?
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-ticketIf this helps, please accept it as a solution and drop a "Kudos" so other members can find it more easily.
Thank you.
9 Replies
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!
😁😁
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 !
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.
This issue usually happens when Power BI is processing a heavy query or is unresponsive. Try minimizing resource usage by closing other applications, waiting a bit longer, or forcing Power BI to close and reopening it. If the issue persists, consider optimizing your query to reduce load time.
Hi HDRA,
May I ask if you have resolved this issue? 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.
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-ticketIf this helps, please accept it as a solution and drop a "Kudos" so other members can find it more easily.
Thank you.
Hi HDRA,
Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.Thank you for your understanding and assistance.
Hello HDRA,
As of now, we are closing this case. If you have any further questions, feel free to reach out to the community by creating a new post, and we’ll be happy to assist you.
Thank you for continuing to use the Microsoft Fabric Community Forum.
