Forum Discussion
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...
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.
Weird.. 🤔
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.