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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MunTah
Frequent Visitor

Two gateways in one report

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?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

4 REPLIES 4
SaiTejaTalasila
Solution Sage
Solution Sage

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
Super User
Super User

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.

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?

Hi @MunTah ,

 

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

 

Thanks,

Sai Teja 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.