How to speed up filter of text search for column filter?

[Anonymous]

I've inserted a new step to my query where I want to search for an individual text string...the search is taking forever. My query doesn't take that long to load but adding this filter step is caused Power Query to just keep thinking...and thinking.

Is there a faster way to add a filter on a column to search for an individaul text string? I have a large data set and I only want to get data fields that match this text string: 503589174. I would think this would go quickly but its' not. I've been stairing at my computer for maybe 30 minutes now.

[v-frfei-msft]

Hi @Anonymous ,

I'd suggest you to filter the data in advance like that.

[Greg_Deckler]

I've seen certain types of operations against certain types of data sources take forever. Usually it is SharePoint, is this a SharePoint list?

One option if worst comes to worst, import all of it and then create a new table in DAX that does the FILTER.

[Anonymous]

The data is from SAP Business Warehouse. The data has already been loaded from Business Warehouse into Power Query...I've just gone back and applied a filter at the very beginning to do some troubleshooting.