Forum Discussion
Power BI – Unexpected Increase in Model Refresh Time and Memory Error
lucaspisso This issue is likely caused by increased data volume, inefficient queries, or complex transformations. Start by reviewing your dataset's size and optimizing transformations in Power Query to reduce memory usage. Consider enabling incremental refresh for large tables to load only new or changed data. If you’re using Power BI Premium, monitor capacity metrics, and increase capacity if necessary. Additionally, simplify the model by reducing columns or measures that aren't essential.
Super Userlucaspisso This issue is likely caused by increased data volume, inefficient queries, or complex transformations. Start by reviewing your dataset's size and optimizing transformations in Power Query to reduce memory usage. Consider enabling incremental refresh for large tables to load only new or changed data. If you’re using Power BI Premium, monitor capacity metrics, and increase capacity if necessary. Additionally, simplify the model by reducing columns or measures that aren't essential.
Thank you very much for your support.
I set up two parameters for the start and end date, and the data updated locally without any issues. However, I noticed that during the loading process, the message "creating a DirectQuery connection" appeared.
Does this change anything compared to before, when I didn't use parameters and was publishing the report to the Power BI service?
Would you like me to help you clarify the technical implications of using parameters with DirectQuery as well?