Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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.
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=....
Try this approach, if you haven't.
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.
letSource = #"XXX"inSource
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.