Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
Solved! Go to 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
Best Regards
Lucien
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
Best Regards
Lucien
What I want to do is kind a "Exemption list" from a Excel file