Forum Discussion
Helper ISuper long refresh times despite incremental refresh
Anonymous Hi!
After some more experimenting and remaking all the calculated columns, reinstalling power bi etc it now works. I also noticed during on of the tests where a refresh took 2 hours, that it completed with a warning, and that warning was referencing a table that wasn't even loaded into the model.
So seems that perhaps some metadata or other stuff had been slightly corrupted? Either way now after rebuild it's only taking 3 minutes to refresh, with the idenditcal aggregation etc...
Super UserGreat detail in those execution logs
Maybe you can try this :
Stagger your refreshes so the two models don't run at the same time
Check the Fabric Capacity Metrics app to see if you're consistently hitting capacity limits during the refresh window
For model 1, trim columns and consider whether the 45-column wide table could be split into a fact + narrow attribute table
For model 2, check if the aggregated table really needs to be in the same semantic model or could be pre-aggregated upstream in a dataflow
Helper IHi!
Thanks for the reply!
For model 1: Would it help to pivot the table?
For model 2: I guess we could pre-aggregate it in snowflake but I'm confused as to why it's needed based on the log details.
With my limited knowledge it seems like that transformation isn't taking that long when reading the log details?
When I check the compute graph it's not over 40-50% load during the refresh, so I don't think that's the culprit