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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
slankapalli
Frequent Visitor

desktop

 HI,

how to load the data faster from SharePoint to desktop, while applying the changes to edit query it has taking a long time to connect to Sharepoint.

 how to reduce the time for connection SharePoint to desktop edit query

2 ACCEPTED SOLUTIONS
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @slankapalli,

 

What changes have you done in Power Query?

 

Do you use multiple references in Power Query, such as Query4 reference to Query 2and Query 3, and Query 2  reference to Query 1?

 

If you use the multiple references which may caused the slow loading, you could use Table.Buffer to help you.

 

Here is a similar thread which has been solved, you could have a good look at.

 

Besides, your network situation is also one of the reasons, you should have a good network environment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

yes, 

 I have solved the problem by disabling the below properties. it will increase the performance  of edit query.

 

 thanks  for supporting.

 

 

 

 

issue_resolved.PNG

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @slankapalli,

 

What changes have you done in Power Query?

 

Do you use multiple references in Power Query, such as Query4 reference to Query 2and Query 3, and Query 2  reference to Query 1?

 

If you use the multiple references which may caused the slow loading, you could use Table.Buffer to help you.

 

Here is a similar thread which has been solved, you could have a good look at.

 

Besides, your network situation is also one of the reasons, you should have a good network environment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

yes, 

 I have solved the problem by disabling the below properties. it will increase the performance  of edit query.

 

 thanks  for supporting.

 

 

 

 

issue_resolved.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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