Skip to main content

Power BI

Needs Votes

Combine multiple Gateway in single dataset/report

Vote (386) Share
S M Atiqur Rahman's profile image

S M Atiqur Rahman on 30 May 2019 13:18:36

Currently, all data sources in a Power BI report/dataset, that are not on cloud, must be available in a single Gateway to work.

But if the datasources in the report are coming from different Gateways, that doesn't work. It is not possible to combine them for refresh.

Say I have a Sales Report. It connects to DB A, B and C.

DB A and B is configured in Gateway X
DB C is configured in Gateway Y.

The report creator have been provided access to all of them.

Now if I try to configure data refresh in PBI Service, it will not work. As none of the Gateway has all 3 DBs. The user can’t connect to DB A and B through Gateway X, and DB C through Gateway Y.

We have to configure all the DBs in the same Gateway to work.

Since in our organization, we have many datasources, and different teams control the access to them, it becomes troublesome, and lots of repetitive data sources has to be created that causes a governance and management headache.

Comments (24)
S M Atiqur Rahman's profile image Profile Picture

Carolinda Vanuitregt on 24 Sep 2024 07:16:20

RE: Combine multiple Gateway in single dataset/report

We need the ability to refresh reports using multiple gateways too. Thankyou

S M Atiqur Rahman's profile image Profile Picture

G J on 20 Feb 2024 15:14:08

RE: Combine multiple Gateway in single dataset/report

We need this functionality too because some of our online resources require the VNET gateway while the on prem source requires the regular on Prem gateway. So currently we can't have both sources in the same semantic model.

S M Atiqur Rahman's profile image Profile Picture

Oleksii Bereza on 12 Jan 2024 16:43:11

RE: Combine multiple Gateway in single dataset/report

We miss this functionality. For security reasons even to connect to Azure SQL we use a gateway and we can not keep PII data in the cloud, so we want to combine Analytical data from DWH with a PII data from OLTP on-prem. For this we need use two separate gateways.

S M Atiqur Rahman's profile image Profile Picture

Olivier Aubert on 27 Jul 2023 12:10:13

RE: Combine multiple Gateway in single dataset/report

We miss such a functionality, for example when doing migration projects in an incremental fashion.

S M Atiqur Rahman's profile image Profile Picture

Jeong-Sim Kellner on 12 Apr 2023 03:01:22

RE: Combine multiple Gateway in single dataset/report

Absolutely needed!

S M Atiqur Rahman's profile image Profile Picture

Pablo J. Moreno on 23 Jan 2023 14:43:31

RE: Combine multiple Gateway in single dataset/report

Absolutelly needed!!

S M Atiqur Rahman's profile image Profile Picture

Sebastian Clementoni on 06 Jun 2022 00:05:18

RE: Combine multiple Gateway in single dataset/report

How is this not available yet?

S M Atiqur Rahman's profile image Profile Picture

Julien DUHART on 28 Apr 2022 08:27:33

RE: Combine multiple Gateway in single dataset/report

It should be really useful and powerful

S M Atiqur Rahman's profile image Profile Picture

Marijn van der Straaten on 30 Nov 2021 13:31:53

RE: Combine multiple Gateway in single dataset/report

This is realy needed

S M Atiqur Rahman's profile image Profile Picture

Fedde Burgers on 30 Nov 2021 13:22:15

RE: Combine multiple Gateway in single dataset/report

Would be really helpfull!