Power Platform Community Forum Thread Details

Hello - Seeking advice regarding what other settings/properties/software functionality might be causing the "Enable Fast Data Load" option under "Refresh control" settings within PowerQuery "Query Properties" to be greyed out. I'm running a macro-enabled workbook, with a single query in it, pulling from one basic flat-pasted data table.

I noticed it was taking upwards of 30 minutes to load the data from a Query to a worksheet, when previously I would have expected this amount of rows/columns to take less than a minute. The query output is 14 columns, and ~200K rows.

Google results led me to this setting/option within query settings, but it's greyed out on my end. After watching some YouTube videos about this feature, it seems that others can easily process 1-10M+ rows of data, in matters of seconds, with this enabled, and also reflected familiar sub-minute times for volumes of data between .25-1.0M rows as I've experienced in work settings before, and would have expected now.

Does anyone have experience using this setting, or have ideas regarding why it's greyed out for me now? I've tried every combination of settings within the three tabs (Usage, Definition, Used In) of this Query Properties menu. I wasn't finding anything in the existing Microsoft Community or simple Google searches.