Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |