Forum Discussion

Icon for Post Patron rank

Post Patron

6 years ago

Solved

Data Refresh in Power BI Service is too Slow

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
6 years ago
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.

3 Replies

V-lianl-msft
Community Support
6 years ago
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
  Post Patron
  6 years ago
  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
    Community Support
    6 years ago
    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.

Related content