Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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,
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
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 😞
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.