- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Memory leak when using PQ advanced editor
I can reliably leak gigabytes of memory per minute when editing M code in the advanced editor, leading to performance degradation of UI interactions and eventually process crashes with out-of-memory errors.
The pbix file I am using is available at https://www.antifound.com/assets/aoc2022.pbix.
The data is all from Advent of Code 2022 and is therefore not sensitive.
Reproduction steps:
- Open the pbix
- Open the PQ window
- Select any existing query
- Open the advanced editor
- Begin adding query steps and editing the code (specifically code and not comments), making sure to leave enough time to get completion pop-ups
- Close the advanced editor
- Close the Power Query window, but do not close Power BI Desktop (applying the new changes does not make a difference)
- Repeat from step 2
By following these steps, I can reliable get my PBI Desktop process up to 10GB of RAM (out of 16GB on the VM) consumed, at which point it becomes unstable and nonresponsive, either crashing with a webview2 memory error or hanging until I kill it through task manager.
Note, that you must have intellisense enabled (the default), and you must interact with intellisense completions while editing code in the advanced editor. Memory consumed by this process seems never to be freed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-
bematth
on: Copying Table with Filters is Ignoring Filters
- tbuck on: March 2025 Update - Error fetching data for this v...
- glendrewsATL on: Snowflake connector isn't showing views after Marc...
- Tomasz_Skoczyla on: March 2025 update - Style preset error
- TwanVerdonschot on: Conditional Formatting - Field Value not working a...
- njf on: Stretched App's Logo in Home Page "Recommended"
- pedrodr99 on: Button Slicer - Label - Color change not working
-
v-xiaoyan-msft on: Default Chart - Shape Map Is Not Working As Expect...
-
v-xiaoyan-msft on: Error (Exception from HRESULT: 0x80070002)
-
v-xiaoyan-msft on: Card (new) - SVG images dont render correctly
- New 7,871
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,149 -
Data Modeling
4,093 -
Dashboards
4,082 -
Gateways
2,103 -
Report Server
2,099 -
APIS and Embedding
1,950 -
Custom Visuals
1,770 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Power BI Desktop
1 -
Tips and Tricks
1