Forum Discussion

TARUGOKING's avatar
TARUGOKING
Helper I
1 year ago
Solved

Semantic Model Takes a Long Time To Refresh

I created my first PBI report using desktop version and published it on the web. The report has 2 datasets,  DS1 has approx 4K records (DimDate), DS2 has has approx 4K records and contains my transac...
Need Help
  • pborah's avatar
    pborah
    1 year ago

    TARUGOKING if your 8AM power bi refresh is clashing with some other loads/processes on the SQL machine around the same time, that could be a culprit.

WishAskedSooner's avatar
WishAskedSooner
Continued Contributor
1 year ago

15 mins? I wish I were you. I have a SINGLE semantic model that is also scheduled to Refresh at 8:00 AM every weekday. I have never seen it refresh faster than 90+ mins.  That's an hour and a half! Nearly two hours! 90+ mins! Let me repeat. 90+ mins!

 

I don't care if you are loading multiple GBs of data on a refresh (I am not), 90+ mins is RIDICULOUS!!!!!!!!!!!!

 

Problem is I don't even know where to begin to troubleshoot. In my mind, it is DOA. In many ways the PBI Service just plain sucks—a half baked product that Microsoft expects its paying customers to beta test.

MasonMA's avatar
MasonMA
Super User
1 year ago

Ecosystem lock-in. I'd say you get used to it 🙂