Errors when trying to Refresh and/or Apply changes in Power Query

Hi Ludzik1993 - Since you’re using Direct Query and Import modes with Dataverse, make sure your transformations are compatible with query folding wherever possible. Complex steps like custom columns or row concatenations might prevent folding, slowing down query evaluation significantly.

Minimize the steps in Power Query, especially if they involve string manipulation on large datasets. Try combining multiple transformations into fewer steps if possible.

Ensure that your VM has adequate CPU and memory. Power BI can be resource-intensive, especially with mixed Direct Query and Import data models.

Running Power BI Desktop on a VM with limited resources can lead to performance issues if other applications are consuming memory or CPU. Close any non-essential applications to free up resources.

Since DirectQuery mode is often more resource-intensive, you may want to consider simplifying your model. Check if some of the tables currently in DirectQuery mode could instead be imported if they aren’t frequently updated.

Optimize Dataverse Queries: If you have access to Dataverse, consider optimizing the database side (e.g., simplifying views, adding indexes) to make the DirectQuery mode more efficient.

since Power BI Desktop WebView2 instability and DirectQuery performance are both areas where updates and patches are regularly released. Each update could potentially address issues specific to VM environments or mixed storage modes.

Solved: Problem with webview2: out of memory error - Microsoft Fabric Community

Solved: Webview2 Process Failed. Out of Memory? - Microsoft Fabric Community