Forum Discussion
Before the data import for __report__ finished, its data source timed out
Hello everyone
Since last week we have experienced errors with scheduled refresh with our reports in PBI Service. We have receiving mostly this message.
The scheduled refresh was running well around 7 months but now we have to update them manually.
More details:
- We have 10 published reports and this problem happens only with 3 of them aleatory every morning.
- The reports consumes mostly text and excel files in shared folders hosted in a local server.
- The on-premise gateway (last version) is installed in the same local server with enought resources: 8 cores and 12 ram.
As a workaroud we are updating them manually from the PBI service but some of them have to be updated using PBI Desktop to publish them again because sometimes the first way fails.
Which other points we should to check?
Regards
1 Reply
It would be helpful if you went ahead and checked the "Refresh History" in the "Settings" section to identify how long it is taking you to refresh the files
From there, you may need to make decisions on how you are going to opitimize your queries or identify if the "Time-Out" error is a result of the conflicting locations of the files. If you are merging or appending certain files from different data sources, there is a chance they may end up conflicting with eachother during the schedule refresh. it may be clever to first set-up dataflows. These dataflows will homogenous your queries and also give you some additional flexibility to monitor and manage them.
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service
If it is not a conflict due to data source heterogeneity, then it is most likely query size/performance based. Solutions such as incremental refresh may solve this issue.
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
