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.

MasonMA's avatar
MasonMA
Super User
1 year ago

TARUGOKING 

Would it be possible you have many transformation steps in Power Query, like nested loops etc. ? or if all queries can be folded to SQL DB, could you run SQL query directly in SSMS and see how long they take? 

 

Also, if i'm in your situation I would consider consolidating these 2 datasets into a single semantic model.

TARUGOKING's avatar
TARUGOKING
Helper I
1 year ago

On-Prem SQL job runs daily at 7:59AM, truncates and populate transaction table, duration 2 secs. Direct SSMS query is 00:00:01. PBI semantic refresh just reads off table where I have 2 renamed columns, 1 column change type, and 2 new measures.  Thanks

  • MasonMA's avatar
    MasonMA
    Super User
    1 year ago

    Weird.. ğŸ¤”

    • TARUGOKING's avatar
      TARUGOKING
      Helper I
      1 year ago

      Just an update:

      • We have 2 reports in Prod. I found out that the other report was running a long time as well. 7+ minutes. 
      • Found out that our on-prem gateway is version 3000.202.13 (DEC 2023)
      • The gateway is running on a Win 2019 Server, 8GB RAM with 2 Processors. The server handles SSO functionality.
      • The Fabric capacity shows 64 Capacity Units and is it a Trial?

       

      Action plan:

      • Will update the gateway.
      • Will beef up the server. 
      • Researching why this is on Trial.

       

      More to come - thanks.