Forum Discussion

Infrabit's avatar
Infrabit
New Member
9 years ago
Solved

Single report with multiple datasources and gateway for some of them

Hi all!

 

I ran in to a problem with one of my customers reports. They have a database onprem which i reachable through gateway. So far so good. Then they added data from an Office 365 Sharepoint List and here the problem starts.

 

The report can no longer be scheduled to run cause the sharepoint datasource is not configured in gateway. But no gateway is needed. If I try to configure a datasource in the gateway for SharePoint I cannot choose a SharePoint connector due to auth-methods. 

 

Preferably I want to use gateway for onprem data and no gateway for Online sources, but cant find a solution for this.

 

Thanks in advance for your help!

 

  • If I recall, you should try using the Personal Gateway to resolve this (and I realize that doesn't make any sense).

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Yes, this has come up a number of times. The issue is mixing on-prem and cloud-based data sources. Are you using the Personal or Enterprise Gateway?

    • Infrabit's avatar
      Infrabit
      New Member

      We´re using the enterprise gateway.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        If I recall, you should try using the Personal Gateway to resolve this (and I realize that doesn't make any sense).