Forum Discussion
Preview refresh was canceled
I am getting this informational message on every query when I first load Power Query
Information: Preview refresh was canceled. If you have disabled the downloading of data previews in the background, this is expected since only one preview will be allowed to refresh at a given time. This has no impact on your loaded data. To see the result of this query, please manually refresh the preview in the Power Query Editor.
I have background download enabled globally
The current file option is therefore greyed out
I found several threads with the same issues, as recently as August 2024 but with no resolution.
Its annoying because I have to refresh each query manually one by one if I want to work on them ... its very time consuming. Has anybody found a fix for this yet?
Thanks
8 Replies
Hi IanDavies - Since you have already enabled background data download globally, confirm that this feature is not overridden by other settings or extensions in Power BI.
If you have multiple queries loaded into Power Query, consider working with fewer queries at a time or disabling the preview for some of them. You can disable previews by right-clicking a query and selecting "Disable Load to Report" for those you don't need actively.
Since this issue has been reported by others as recently as August 2024, there might be ongoing investigation or a workaround from Microsoft. Submitting a ticket can also help prioritize the issue.
alternative workaround:
If you frequently face issues with Power Query in Power BI Desktop, consider using Excel Power Query to pre-process data and then load the cleaned data into Power BI.
Hope this helps.
I don't have any 3rd party plugins so i think its unlikley IMO
I hadnt considered using PQ in Excel as any different than using PQ in PBI but will see if I can redo what Ive done so far and if it fixes the issue.
I don't know how to raise a suport ticket, or even if I can.Hi IanDavies - Since you've considered redoing your work in Excel, this might help narrow down whether the issue is specific to Power BI or is data-related.
Support ticket link:
Microsoft Fabric Support and Status | Microsoft Fabric
Provide details about the issue, such as when it occurs, steps you've tried, and screenshots if applicable.
I have built an excel workbook usign the same PowerQuery transformations (copied/pasetd the code from advanced editor) and I am having a similar isue in Excel.
It looks to be a timeout as the tabe is quite large and loads from an attachment in a mailbox.
I will investigate reducing the size of the tables involved and if that doesnt work I'll ask how to raise a support call.
Thanks for the help.can you increase the timeout value?
maybe separating the big table into a dataflow would be better and then ingest it from the dataflow. How are you processing the task? what code?
how many tables are there?
There are currently 11 of various sizes some very small e.g. 2 columns ten rows, others are much larger with 6000+ rows and p to 80+ columns (which I intend to reduce once I have the data in a clean and useable format with a unique key across all queries)
