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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi TARUGOKING,

Thank you for sharing the updates. Please keep us informed.

We are also checking to see if the information we shared helped you solve your problem.
If you have any more questions, feel free to ask the Microsoft Fabric community.


Thank you.

  • 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 🙂