Data Refresh in Power BI Service is too Slow

[nagaraj]

Hi,

 I have a report with size 400 MB, the data refresh in Desktop it took hardly 3 mins.

When i try to refresh from Power BI Service manually, the data  refresh is very slow so far it took 40 mins still running.

Not sure is this expected else can you suggest how to resolve.

Is there any way to stop this Manual Refresh

Regards

Nagaraj

[V-lianl-msft]

Hi @nagaraj ,

Is your gateway the latest version? Probably check if your gateway machine run out of disk/memory?Make sure that it has got enough memory, CPU and bandwidth to both the source data and Power BI service.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nagaraj]

Hi,

 I have total 15 tables in my dataset and for 1 Fact table i made it INCREMENTAL REFRESH now. After publishing when i try to REFRESH manually a window pops up saying "Preparng for REFRESH" and I am not seeing anything after that. Not sure what is the issue

Regards

Nagaraj

[V-lianl-msft · Accepted solution]

Hi @nagaraj ,

In cases where the filter is not supported by the datasource back-end, it cannot be pushed down. In such cases, the mashup engine compensates and applies the filter locally, which may require retrieving the full dataset from the data source.

The first refresh in the Power BI service may take longer to import all the range. Subsequent refreshes may be finished in a fraction of the time.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.