Hello,
We are having 4 reports (4 separate pbix files) published in one of our Teams Spaces. The reports are scheduled to be automatically refreshed every one hour (all 4 reports are synced at the same time).
In 2 of the reports, we are using a lot of Views, coming from our MySQL DB - 16 views. The biggest view we have returns ~200K records.
The issue we are facing is related to the automatically refreshed data which seems that on a random basis returns a different set of data (just a piece of the data, not all records). I have noticed that the problem occurs only for the reports that use the biggest views.
If I go and manually (app.powerbi.com) sync the data for just one report, in case I notice the data is missing, all the data from the views is loaded correctly. It is the same if I sync the data in PowerBI Desktop.
The automatic sync is done through the Gateway.
Do you have an idea what could be the reason for this behavior?
The only thing which is coming to my mind is - all the reports extract one and the same data at the same time, which could result in a problem in the Gateway or in DB.
PS: The sync in PowerBI Desktop takes ~1.5 mins for the biggest report, while the sync of all reports (at one and the same time) takes 14-15 mins per report.
