Single report with multiple datasources and gateway for some of them

[Infrabit]

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!

[Greg_Deckler]

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]

We´re using the enterprise gateway.

[Greg_Deckler · Accepted solution]

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

[Infrabit]

As you say, doesn't make sense but works like a charm. 

I'm happy with that solution. Thanks a lot!

[Greg_Deckler]

No problem! Happy to help!