Forum Discussion

estankova's avatar
estankova
Frequent Visitor
6 years ago
Solved

Data source credentials blocked after Appending tables

Hello! I have two tables in query editor. After Publishing - Credentials is avaliable (ok). But after I appended these tables in query editors - Credentials isn't avaliable and refresh is faillure...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , estankova 

    Before appending, you only needs to configure the gateway for your sql server datasource, but after appending, your online sharepoint must also be configure in the datasource.

    From your picture , It  seems that you are not the gateway's admin and cannot add the datasource (two sharepoints) to the gateway(which is commonly known as Add to gateway option,)

    After appending the datasource of online and on premises, you need to configure the gateway for the online source.

    So please find the gateway admin to configure the two sharepoint datasources, and then you   will see the  Option of maps to " xxxx".

    Best Regards,
    Community Support Team _ Eason

estankova's avatar
estankova
Frequent Visitor
6 years ago

v-easonf-msft 

After Append and Publish Gateway Connection is disable.

After Apeended

Before Append

 

 

 

 

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , estankova 

Before appending, you only needs to configure the gateway for your sql server datasource, but after appending, your online sharepoint must also be configure in the datasource.

From your picture , It  seems that you are not the gateway's admin and cannot add the datasource (two sharepoints) to the gateway(which is commonly known as Add to gateway option,)

After appending the datasource of online and on premises, you need to configure the gateway for the online source.

So please find the gateway admin to configure the two sharepoint datasources, and then you   will see the  Option of maps to " xxxx".

Best Regards,
Community Support Team _ Eason