Can't add data source to gateway

[Syndicate_Admin]

Hi all,

I'm facing issues with connecting my data source to my gateway on power BI.

In the parameters of my data set, we can see it's not connected to the gateway.

I click on "add manually to the gateway", which prompt me a form to add credentials to my data source.

It registers fine, but  when I come back to the parameters, it gives me the same "incorrect configuration" message.

Any help?

Many thanks

[v-jingzhang · Accepted solution]

Hi @ACF-Alice

You could refer to these docs about adding a data source to the gateway:

Manage your data source - Import/scheduled refresh - Power BI | Microsoft Docs

Add or remove a gateway data source - Power BI | Microsoft Docs

According to the error message, it seems that the data source in this dataset cannot match a data source on the gateway, so it reminds you to add the data source manually to the gateway. Please notice that the server and database names must match between Power BI Desktop and the data source within the on-premises data gateway. The link between your dataset and the data source within the gateway is based on your server name and database name. These names must match. For example, if you supply an IP address for the server name within Power BI Desktop, you must use the IP address for the data source within the gateway configuration. If you use SERVER\INSTANCE in Power BI Desktop, you also must use it within the data source configured for the gateway.

In addition, after adding this data source to the gateway, select Manage Users from the top ribbon to check the user list of this data source. Ensure that you have access to use this data source. 

If you're listed in the Users tab of the data source configured in the gateway, and the server and database name match, you see the gateway as an option to use with scheduled refresh.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.