Help: refresh is timing out in service

[ajin]

Hi Guys, 

I m currently facing the below issue in pbi services while trying to refersh the dataset . The same dataset refresh's in desktop.( the dataset is  oracle sql ).  Further It takes more than 5 hours to refresh in desktop. 

 

[v-yuta-msft]

Hi ajin,

About how to improve the performance of query, please refer this documentation: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#performance.

Regards,

Jimmy Tao

[ajin]

Further will splitting the data set up into smaller tables help, in reducing  the refresh time ?