2 Gateways one Semantic Model

[Axiomite]

Hi there, 

Im trying to achieve the following:
I create a Report with 2 datasource, one from a SQL db and the other Excel, on desktop

1. Datasource01 points to a SQL server which I access via a VPN (On-Prem gateway01)
2. Datasourc02 is an Exel sheet stored on the PC I'm working on. (also with a personal on prem gateway)

When I publish I get the message: report.pbix is not connected to on or more data sources. to connect....

It looks like this on the service

I click on add to gateway but keep on getting the same errors

Any ideas? 

Kind Regards

[lbendlin]

One workaround is to stuff one or more of the data sources into a dataflow, then you can mash them up as you want, without that gateway limitation.

[aj1973 · Accepted solution]

Hi @Axiomite 

As @TomMartens said, you Can't use 2 Gateways for the same Dataset.

You need to correctly configure the Standard Gateway BMS

And then add the path of your file to the Gateway BMS

Maybe it would be easier if you uploaded your file data.csv to the SQL Server or to Sharepoint.

[TomMartens]

Hey @Axiomite ,

all data sources of a dataset have to utilize the same gateway.

Regards,

Tom