Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Mageshwara
Regular Visitor

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

7 REPLIES 7
v-jingzhang
Community Support
Community Support

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

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

 

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.

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja
AnkitKukreja
Super User
Super User

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.

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja

Hi @AnkitKukreja 

 

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

Hi! @Mageshwara 

 

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

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja

Hi @AnkitKukreja 

 

Thanks

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors