cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abukapsoun Member
Member

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 4
abukapsoun Member
Member

Re: Slow sharepoint list

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.

 

Sunkari Member
Member

Re: Slow sharepoint list

abukapsoun Member
Member

Re: Slow sharepoint list

Nope, didn't help much Smiley Sad

Community Support Team
Community Support Team

Re: Slow sharepoint list

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

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