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.
Post PatronHi,
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
Community SupportHi 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.