"Filter data by encoding on separate excel file" is this possible?

[RodolfoGalit]

Hi Ladies & Gents,

Is it possible to filter out data from the field by encoding that entry on a linked (separate) excel file? Or it can only be done in Power query and Filter options in BI?

Thank you in advance!!

[v-luwang-msft · Accepted solution]

Hi @RodolfoGalit ,

As far as I know, the only way to filter in Power BI, or when importing, check the report and then load the data after the filtering is done in Power Query, is as follows.

And similar question refer:

https://community.powerbi.com/t5/Desktop/How-to-filter-excel-data-during-load-to-Power-BI/m-p/881673 

https://community.powerbi.com/t5/Power-Query/Filter-data-before-import/td-p/2196475 

https://community.powerbi.com/t5/Desktop/Filters-Data-before-from-excel-it-gets-imported-to-power-bi... 

Best Regards

Lucien

[RodolfoGalit]

What I want to do is kind a "Exemption list" from a Excel file