I through direct query made pbix file, launch it, tip: "has been successfully published, but issued statements unable to connect to a data source, because we can't find the gateway, please make enterprise gateway", but I am in the unit has been installed the gateway, the gateway when logging in for the first time, looked normal, but in the "service set" select "immediately after the restart, it prompts:" gateway service is not running, click details: "service" control panel to ensure that the running in "on-premises data gateway services", but I confirm in the service control panel, the service is running, what should be how to solve this problem,

CodePudding user response:

Hi maoben,
May be caused by several different reasons:

You enter in the Power BI Desktop server and database name and gateway in a data source name not consistent, the value must be the same, can be case-insensitive, gateway configuration of data sources not listed on the users TAB of your account, will have to deal with the gateway to be added to the corresponding list of administrator, Power BI with multiple data sources in the Desktop file, not all of these data sources are configured to gateway data source,
You can also choose to install the gateway look to whether can solve the problem, steps are as follows:

Uninstall gateway, remove the folder: "c: \ Program Files \ on-premises data gateway", "
Reinstall the gateway,
Details please refer to: the local data gateway troubleshooting

CodePudding user response:

Hi maoben,
May be caused by several different reasons:

You enter in the Power BI Desktop server and database name and gateway in a data source name not consistent, the value must be the same, can be case-insensitive, gateway configuration of data sources not listed on the users TAB of your account, will have to deal with the gateway to be added to the corresponding list of administrator, Power BI with multiple data sources in the Desktop file, not all of these data sources are configured to gateway data source,
You can also choose to install the gateway look to whether can solve the problem, steps are as follows:

Uninstall gateway, remove the folder: "c: \ Program Files \ on-premises data gateway", "
Reinstall the gateway,
Details please refer to: the local data gateway troubleshooting

CodePudding user response:

Thank you, problem solved,

CodePudding user response:

After installing the gateway to a data source set up automatic refresh, always show what the devil is not properly configured, what data sources are added, has always been show did not properly configured, the zha