Power Pivot data model slow refresh

Hi some_bih,

Thanks for replying to my post, appreciate your feedback.  I tried clearing cache but that didn't help unfortunately.  I ended up splitting the model into two files, one for each fact table.  Doing it this way helped me to see that the problem was with the model linked to the smaller fact table.  Still haven't figured out the exact root cause of the problem though, but I can work on the smaller fact table model later.

I'll check to see if I'm allowed to download the diagnostic tool and see if that helps.  I'll also check if working in PBI makes a difference.

Thanks again!