Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |