Forum Discussion

Mageshwara's avatar
Mageshwara
Regular Visitor
4 years ago

Power Query slow for particular Sharepoint file

Hi All, i am using power query to get the data from two files which is in the same sharepoint path, but i can get the date from one file faster and another one takes too much time to load the date, c...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Mageshwara 

 

Does that slow query have many complex transformation steps? Transformations in Power Query will also make the query time longer. 

 

Best Regards,
Community Support Team _ Jing

Mageshwara's avatar
Mageshwara
Regular Visitor
4 years ago

Hi v-jingzhang !

 

Thanks !

 

I think so , Data transformations were happening while fetching the data, Can you please help me to how to disable that and what is the use of data transformations?

 

Thanks in advance

 

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    4 years ago

    Hi! Mageshwara 

     

    What v-jingzhang means is if you are using the transformations which can be avoided should be deleted. Very basic examples are like reordering a column, sorting the data, etc.

    Try to manage your transformation in data as much as possible.