Solved: Data Source Error - Scheduled Refresh

Beniya_Sam_14 · ‎06-14-2023

Hello All,

My report hasn't been refreshed for past 2 weeks. It shows below error. However it works in desktop. The refresh usually takes 20 mins. The data has 52,00,000 rows and data size is 345 MB and we are using Pro License. In power BI service, it takes 2 hours and ended up showing this error. This dataset running smoothly for past 2months now it showing this error.

Data source error: {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}}

Thank you

lbendlin · ‎06-19-2023

Personal gateway is not supposed to be installed on a server. It is an app on your PC. If that app is not running then you get the "unavailable" message. On your server VM install the Enterprise gateway which is a service.

View solution in original post

lbendlin · ‎06-18-2023

Please provide more details. Personal or Standard gateway? what are the data sources?

Beniya_Sam_14 · ‎06-18-2023

@lbendlin

We have installed Personal Gateway in our Server

Data Source: MYSQL

lbendlin · ‎06-19-2023

Personal gateway is not supposed to be installed on a server. It is an app on your PC. If that app is not running then you get the "unavailable" message. On your server VM install the Enterprise gateway which is a service.