Forum Discussion
Data Flows Schedule refresh not working consistently - Urgent help needed
Hello Community,
I want to bring this as a fresh discussion and seek help on managing data flows schedule refresh. There is one data flow i have created and i knew that it holds only 30 records. However , it takes more 30 minutes to refresh the data flow. Am I doing something wrong in following processes ?
Some where i read that If I am under premium capacity, they suggested to run datasets/dataflows at different times. But i checked the schedules and not more than 5 datasets are running currently. In this way, I am not getting good use of dataflows and unable to convey pros of using data flows with clients .
I am under Premium capacity and sure that environment doesnt have any momory issues as well. Could some one tell how to get rid of this situation ?
Thanks,
G VEnkatesh
36 Replies
- GilbertQ
Super User
Hi there
can you have a look at the premium metrics capacity app and see what is happening at the time of refresh.
Also review this whitepaper to help you troubleshoot performance issues.
https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-scenarios- AnonymousNot applicable
Hi Gilbert,
Thanks a lot for sharing those whitepapers. This information is very useful . I have reached out to Power BI Admin in my org. I have gone through some of those Statistics ( CPU Utilization and Memory usage) which we need to look at . I see that only 10 GB of Memory added for data flows . While my admin is yet to get back to me about the usage details, I would like to know if there is a way to increase this limits so that the dataflows will run faster .
At this time, I am just looking for one thing . I want my Dataflows to RUN FAST to make sure data is not old in my reports . We are not concerned about buying new hardware or clean up/flush out memory for dataflows to run fast.
Please assist !!!
Thanks,
G Venkatesh
Thanks,
G Venkatesh
- AnonymousNot applicable
Hi Gilbert/Community,
Also attaching the health statistics (metrics) currently we have our Premium capacity. While there are metrics for datasets and paginated reports as well, but i am particularly looking at dataflows only.
Based on this, What does you suggest for us to have the dataflows refresh quickly ? Also to avoid seeing stale data in reports, what is the frequency of refreshes i can do on each data flow ?
Thanks,
G Venkatesh
- v-lili6-msft
Community Support
hi Anonymous
You may try to restart the capacity to if it get better.
https://docs.microsoft.com/en-us/power-bi/service-admin-premium-restart
Regards,
Lin
- AnonymousNot applicable
Hi Lin,
Sure .Thanks for the suggestions. We would certainly restart the premium capacity as a measure to free up the memory.
Thanks,
G venkatesh