Forum Discussion
Dataflow & Dataset refresh is an hour stale
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!
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.
1 Reply
v-xicaiCommunity Support
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.