Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Unable to connect to the data source

Following issue:

Unable to connect to the data source undefined.

  • Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
    Activity ID971636be-3094-4501-a070-6ba3d107fe2e
    Request ID4de10842-6c42-63e5-f5e0-5ebe2f34673d
    Time2022-08-02 07:01:11Z

On-premises data gateway is updated and online.

Data sources refresh perfectly on the Desktop version, so no user RLS applicable.

 

Gateway connection to single SQL datasource has not changed at all since issue started.

 

Please advise

 

 

Status: Investigating

Hi @FIN_CI ,

 

To troubleshoot this issue, please let me know the following details. Thanks in advance!

1 Which user credentials is being used to add the data source to the gateway.

2 Who is the administrator of the machine where gateway is running.

3 Are your database and gateway installed on the same machine?

4 Is the credential has sufficient permissions to access the resources on the machine installed gateway?

 

In addition, please check the connection status of your data source in Manage Gateways if you are using Standard mode gateway and check the configuration in Dataset Settings page. Make sure data source used in dataset has mapped to the proper registered data source on gateway.

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

Hi @FIN_CI ,

 

To troubleshoot this issue, please let me know the following details. Thanks in advance!

1 Which user credentials is being used to add the data source to the gateway.

2 Who is the administrator of the machine where gateway is running.

3 Are your database and gateway installed on the same machine?

4 Is the credential has sufficient permissions to access the resources on the machine installed gateway?

 

In addition, please check the connection status of your data source in Manage Gateways if you are using Standard mode gateway and check the configuration in Dataset Settings page. Make sure data source used in dataset has mapped to the proper registered data source on gateway.

 

Best Regards,

Community Support Team _ Caiyun