Time Out Error while refreshing on Power BI service
I have created a dashboard with source 'IBM DB2 database'. I have 5 tables related as shown in the screenshot.
The tables contains data in millions,
The report is published to Power BI service. we are using On premises gateway to schedule a refresh but it is getting failed after running for around 2 hours. The time out duration is also given as 5 hours in the data source.
The same data is getting refreshed when we try it from the Power BI desktop. It is throwing below 'Time out error'