Forum Discussion
PBI Model refresh failed when the whole source dataset is updated.
I have a powerBI Model that is published to PBI Service with Incremental refresh setup for last 1 day.
Today My databricks (Source data for PBI Model) tables with data are truncated and uploaded. But my PBI model did not refresh with the latest data.
The error :
Resource Governing: This operation was canceled because there wasn't enough memory to finish running it. Either reduce the memory footprint of your dataset by doing things such as limiting the amount of imported data, or if using Power BI Premium, increase the memory of the Premium capacity where this dataset is hosted. More details: consumed memory 17466 MB, memory limit 17466 MB, database size before command execution 8133 MB. See https://go.microsoft.com/fwlink/?linkid=2159753 to learn more.
Incremental Refresh :
Set to 5 Months, Refresh for last 1 day and detect data changes based on modifieddate.
I checked the modified date and it is perfect at my source data.
Hi anilkolla405,
In fact, the error message clearly mentions the refresh operation canceled due to memory resource not enough. You may need to add filters on the source records to reduce the data amount or increase the Premium capacity memory resource to resolve this issue.
Regards,
Xiaoxin Sheng
1 Reply
Hi anilkolla405,
In fact, the error message clearly mentions the refresh operation canceled due to memory resource not enough. You may need to add filters on the source records to reduce the data amount or increase the Premium capacity memory resource to resolve this issue.
Regards,
Xiaoxin Sheng