Yes Buddy.. I tried that and i didnt find any issues . we have almost 150 reports which run on this gateway every day and they are even scheduled to refresh every one hour (datasets) . we didnt come across any major issues.
on other end, I captured the refresh history shown in screen shot below. It says that when we are approaching business hours(EST ) , data flows started taking more time or not executing at all. In off hours, they run pretty quick. But I am not sure how to make the data refreshed in this business hours where more users login and look for reports.
Kindly assist !!
Yes we do have (Say some 25 datasets) . But given a seperate memory allocation for data flows(10 gb), we expect the data flows to run fast . If not, data flows can never be a solution for us .
Please assist !
I attached one more screen shot. This data flow contain a single entity which retrieves only 30 records. Just before some time, it just took few seconds to complete. However, it is still running when i triggered it now.
I want to post some more updates regarding the issue.
- In the workspace data flows are residing , Only 2 dataset refreshes are happening at this time when data flow is refreshing .
- There are no paginated reports running at all.
I have provided sufficient information. So i would request you to provide me suggestions based on information i have provided.
Try to run dataflows refresh on their own without any other dataset that could make contention on Gateway and see if something changes.
I will try to do that . I do not want to stop the refreshes in between.
Would creating a seperate workspace for data flows a good idea?
If the problem is caused by preassure on the Gateway or because of low resources setup at capacity level it won't solve your issue.
Could you please tell me how i have to check the resources that are set up at capacity level ? As far as i know, We are runing on P1 which holds more capacity. I understand there are many other workspaces in my Org that uses resources. We though being on premium services can help us run n number of reports and resources are enough to manage datasets refreshes and data flows .
We looked at Memory space and CPU utilisation. What else we can check to make sure there is nothing wrong we are doing from environment side .
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications
Features releasing from October 2020 through March 2021