How to clear an applied filter of online Excel

[corpsikumar]

Hello Power users,

I have an exel file in sharepoint and loaded into power bi. Everything works fine until there is someone goes into that excel and applied the filter, they quit the file without clearing the filter so that the power bi will only loading only filtered data. 

How can we clear an applied filter of online Excel and load entire excel file.

Thanks

[v-easonf-msft · Accepted solution]

Hi, @corpsikumar 

I think you might consider disabling the refresh of report data.

Re-enable the refresh of report data when you need to load the filtered report data.

Managing query refresh in Power BI 

Best Regards,
Community Support Team _ Eason

[ribisht17]

@corpsikumar 

Power BI depends upon the data source it is connected to, not vice versa.

Please ensure that data-source is filtered properly, data-source will be high up in the order of operations

Regards,

Ritesh