Forum Discussion

Vtomsons's avatar
Vtomsons
Helper I
4 years ago
Solved

Filter database added to my source data

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 ad...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
JotaL
Frequent Visitor
3 years ago

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.