Two gateways in one report

[MunTah]

Hello,

I'm facing a challenge with my gateways where I have a report which uses A. SQL on premise B. PostGreSQL. As soon as I try to set a automated refresh on my report, I get an error message. I assume that I can't use two different gateways and each and every one is connect to a specific database. How can I create a cluster which combines 1. Gateway for SQL 2. Gateway towards postgresql 

is it even possible to do that? What are the other solutions which you recommend to overcome this?

[SaiTejaTalasila]

Hi @lbendlin ,

You can go with a dataflow.Import your tables to a dataflow and consume/import data from dataflow to reports.

Thanks,

Sai Teja 

[lbendlin · Accepted solution]

There is a limitation but it doesn't seem to be applicable to your scenario.  The limitation is that "All on-premise data sources in your semantic model must be served by the same gateway".  You can work around that limitation by using dataflows for some of your data sources.

Anyway, your scenario seems to be different.  Please describe again what your setup is, which data sources are on-premise and which are cloud based.

[MunTah]

Appreciate the answer. 

The PostgreSQL is on the cloud and the other data source is on-premise. I have in total two gateways, one is for the PostgreSQL and the other one is for on-premise. 
My raport has to use both data sources. 

The work around though dataflow sounds undoubtably doable and I might just have to give up the cluster solution which might give me the possibility to combine those two different gateways?

[SaiTejaTalasila]

Hi @MunTah ,

You can create the connections on same gateway cluster.Why you need to keep them two gateways?

Thanks,

Sai Teja