Forum Discussion
Power Pivot data model slow refresh
Hi all, I have a data model in Power Pivot that takes a very long time to update whenever I make small changes. It consists of two fact tables; one with 190K rows and another with 1.2K rows. Proba...
Hi jkapso751 I like to use power pivot, but at some point of time (model size) it crash and it makes me crazy. It could be that in your case the workbook and model reach similar point.
Firstly, try to delete query "clear cache" in Data>>>Query options. Check results
What I did is simple imort model into Power BI and continue work there - this is good alternative.
To trace diagnostic as much as possible, check your model with tool from link
https://www.sqlbi.com/tools/power-pivot-utilities/
Did I answer your question? Mark my post as a solution! Kudos Appreciated!