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
Ros-ec
Helper I
Helper I

Three power bi gateways and 4 data sets to combine into one powerbi report?

Hi,

I have two SQL databases on one platform where the tables have been combined to report on the offices in a single power bi report.

I then have 2 other sql databases (of the same type) that exists on two other platforms (3 platforms all together). A gateway has been set up for each. However, I can't see away in the power bi report to link to each gateway, then the sql data to combine all the 4 databases together into the same report for all the offices?

How can this be done?

Thank you for your help

Best wishes

Ros

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @Ros-ec 

 

If the databases are Azure SQL Databases you do not need a gateway and that could work.

 

Otherwise you can only use a single gateway to a dataset (Power BI Report/dataset). So you would need to create 2 new data sources on a single gateway in order to connect the dataset using the gateway.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes, we have decided to have a server that can point to each of the data sets and then a gateway to that server through power bi. Thanks for your help.

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.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.