Slow refresh of SharePoint list data

[ccueto36]

Hi guys,

I have a table whose data source is a Sharepoint Online list, it's not a lot of data, barely 3MB. However, it takes minutes to load the data and it loads 3KB per second or so, which is ridiculous. There are no network problems. I have already attempted to use Table.Buffer preceding Source = Sharepoint.Tables(URL) but it doesn't change anything at all. As a side note, the returned table contains a Record column which I am expanding in the data model. Any ideas? Thank you in advance.

[Anonymous]

I had the same problem, the solution found by my team was to migrate the data to sql through microsoft flow.

[Anonymous]

@ccueto36,

Do you mean that it takes minutes to load data to Power BI when you firstly import from sharepoint list, or it is slow when you refresh data/apply query change in Power BI Desktop?

If you mean the first time that you import data, please disable the following options in Power BI Desktop.



However, if you refer to the refresh/apply query change time, please review the discussion in the similar thread below.

https://social.technet.microsoft.com/Forums/Lync/en-US/37765819-f2b8-48f6-aaa9-3b9a8716a947/sharepoi...

Regards,
Lydia

[mvrali]

What is the alternative to exapanding the columns? In the link you provided they mentioned using lookupvalues but how they achieved it? Was it DAX or m?