Error loading data from SharePoint

[FNI22]

Hi!

I need your support with the following, when I try to refresh the dataset from Power Query it takes a long time without finishing (almost 14 hours running with no results). I am pulling the data from a SharePoint site and I don't know what is happening.

Has anyone faced something similar?

[v-yingjl]

Hi @FNI22 ,

Besides considering the data souce size, you can enable diagnostics in Power Query to check each query time to find the corressponding issue.

Refer: Query Diagnostics 

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

[themistoklis]

@FNI22 

You should check the following:

The size of the dataset in sharepoint?

The format of the dataset (csv, xlsx... etc)

Are you performing any transformations in Power Query? Then you should check if there is a step in PQ that takes long time to run