Discard filter when data is uploaded
Hi, I have a scheduled upload form an Excel file on my OneDrive. That file is shared with several people and sometimes they apply filters, when the scheduled refresh occurs and a filter is applied only the filtered data is loaded. Is there a way to load all the data, regardless of the filter applied in the Excel file? Thanks.