Forum Discussion
TARUGOKING
Helper I
Helper ISemantic 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.
pborah
Solution Sage
Solution SageTARUGOKING 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.
TARUGOKINGHelper I
Helper ISo while investigating this issue, I found out that we have another PBI report that updates at 8AM. This report takes 7 mins. I moved my refresh to 7:30AM. It now takes about 4~5 mins to refresh. A far cry from the 15 mins load but still not really a desirable time frame.