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, can you please help me with this.. Comparatively the faster one is the big file size

Need Help

7 Replies

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    4 years ago

    Hi! Mageshwara 

     

    This could generally happen if multiple users are using the file at that time. Can you try changing the path of that file and test again if that works or not? If that doesn't work try to remove the file and add it back.

     

    • Mageshwara's avatar
      Mageshwara
      Regular Visitor
      4 years ago

      Hi AnkitKukreja 

       

      Thanks , I tried the same but same slowness in Different path and And re uploaded the file again

  • 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
        3 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.