Dataflow & Dataset refresh is an hour stale

[Anonymous]

Hello,

I own a report that connects to a Dataset which is connected to a Dataflow. Both the Dataset and Dataflow are set to refresh every 30 minutes and take about 2-3 minutes to refresh. For whatever reason my report (which has an indicator of when it was last refreshed in the report) will say that the most recent refresh was from 1 minute ago-almost 1 hour ago. My refreshes never fail. Is there any way to bring my latest refresh to under 30 minutes? What could I be doing wrong?

Thanks!

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may need to improve the dataflow performance:

Use incremental refresh for dataflow, see more detail:https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh.

If you have a Premium license, you will have access to more or fewer functionalities within Dataflow, see more: https://blogs.solidq.com/en/businessanalytics/power-bi-dataflows-how-does-the-new-tool-work/.

(Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.)

Also, you can improve the dataset performance, see: https://community.powerbi.com/t5/Service/SQLServer-performace-issue-will-dataflows-help/td-p/783770.

Best Regards,

Amy

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