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
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

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    4 years ago

    Hi! Mageshwara 

     

    Then I'm very confident that this could be due to the source i.e. SP.

     

    • Mageshwara's avatar
      Mageshwara
      Regular Visitor
      4 years ago

      Hi AnkitKukreja 

       

      Thanks

       

      Yes, Now i removed the blank rows , Now its getting lesser time compared before