Slow sharepoint list

[abukapsoun]

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,

[v-jiascu-msft]

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=....

Best Regards!

Dale

[Sunkari]

Try this approach, if you haven't.

https://community.powerbi.com/t5/Desktop/Slow-refresh-of-SharePoint-list-data/m-p/134926#M57747

[abukapsoun]

Nope, didn't help much 😞

[abukapsoun]

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
Source

How 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.