Forum Discussion
Post PatronData Refresh in Power BI Service is too Slow
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.
Community SupportHi 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.
nagarajHi,
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
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.