Forum Discussion
Slow sharepoint list
Hi Gents,
I have a problem I am not sure how to overcome. I am importing my query from a sharepoint list which has almost 1000 rows. But each time i modify the query, it takes almost 30 minutes to save 5 Mb.
I tried to create DIM tables out of the original query using references and unloading the original table, but still when I save, the same thing happens.
I disabled the preview download in the background as well.
Thanks,
4 Replies
How can I enable the table.buffer to the source? I am not able to identify the syntax of the command.
let
Source = #"XXX"
in
SourceHow should I modify the Source = #"XXX" to have table.buffer?
I tried Source = table.buffer("XXX") but it is giving me the following error
Expression.Error: The name 'list.buffer' wasn't recognized. Make sure it's spelled correctly.
Try this approach, if you haven't.
https://community.powerbi.com/t5/Desktop/Slow-refresh-of-SharePoint-list-data/m-p/134926#M57747
Nope, didn't help much :(
Hi abukapsoun,
Did you mean " to save 5 Mb" is "Apply queries changes" when clicking "Close & Apply"? Or just saving the PBIX file?
1. If it happened when saving the PBIX file, try to debug with creating another file;
2. If it happened when clicking "Close & Apply", maybe you need to optimize the queries. According to my test, it's reasonable.
BTW, please upgrade Power BI Desktop to the latest verion: https://www.microsoft.com/en-us/download/details.aspx?id=45331&751be11f-ede8-5a0c-058c-2ee190a24fa6=True.
Best Regards!
Dale
