Forum Discussion
Not enough memory error for powerbi data refresh on fabric workspace
Hi We have been using power bi pro licenses and we gets various data tables from Azure SQL server to powerbi. Total data size of all data being synched to powerbi is 940 MB My company has decide...
Consider optimizing the calculated columns and tables. Instead of using Power BI for calculations, you can create those calculated columns at the server level using an SQL query.
You can also reduce the data size by filtering it to the last 2 years if you have historical data beyond that. Remember, calculated columns or tables process all rows in the table, which can consume more memory.
I used a similar approach in the past when I faced the same issue.