Filter database added to my source data

[Vtomsons]

I am having issues refreshing my data then I came across this extra row in my data source. I think this filter is effecting part of my refresh. How did I do this and how do I get rid of it without adding a step in my navigation that will mess up future refresh?

[v-stephen-msft · Accepted solution]

Hi @Vtomsons ,

Do you want to filter data before connecting to the data source? It is about query folding.

Query folding | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JotaL]

I have the same issue as the one that is posted here. However, the same query was used with different files, all data exports from an cost estimating tool, and this behavior just happens with one of those exports. 

All the export files look the same, as they use a standard structure in that tool. The only difference is that this precise export has 9000 rows, and all others have around 2000. But while the others take 12 seconds approximately to complete the transformation, this one takes 12 minutes to retrieve the source data and then few seconds to transform.

I do not understand this difference.

I use the  Source = Excel.Workbook(File.Contents(FileName)) being FileName the parameter with the file full path.

[Anonymous]

Hello @Vtomsons 

You can filer out that row as your first step and then try to perform another transformation.

I hope this works. In case it doesn't work for you. Could you please share the file after removing the sensitive information?

Thank You.