Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dataset taking a long time to refresh

Hi,

 

I have a dataset that gathers data from 6 different SQL views with the max number of rows in any one of the views around 1,000.

 

If I refresh the dataset in Power BI Desktop it usually takes seconds, but it can take up to a minute depending on network traffic. The problem I have is that the same dataset refresh on powerbi.com takes anything from a minute upto 45 minutes. 

 

I appreciate there are additional variables with the web service vs the desktop refresh, but I just feel something is not quite right. I'm trying to debug the problem but I can't see anywhere I can monitor or track exactly what powerbi.com is doing when the dataset is being refreshed.

 

Has anyone come up against this issue before and did you manage to find a solution?

 

Thanks very much in advance,

 

Chris

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    I have seen this happen in the past.

    You can monitor this on your Gateway via enabling the monitoring metrics and verbose logging to see where the delay is.

    Also if you are only refreshing your dataset once a day or every few hours I would suggest just leaving it as is.