Forum Discussion
Slow refresh of SharePoint list data
I have a report that currently retreives data from a large Sharepoint list, and two Sharepoint folders. The refresh time was fine until two days ago, when it grew from a few minutes to more than few...
Hi Anonymous,
1. Where did you refresh data spend long time, desktop or service? From your description, it seems there is a custom function defined in query, can you share how did you define it? If you just get SharePoint list data without any custom function, is the refresh time normally? Please share detail steps how did you get data so that we can try to reproduce the issue on our side.
2. As you mentioned when you open Query Editor, the data source connects to SSAS throws out error, what's the error message?
Best Regards,
Qiuyun Yu