Forum Discussion
2 Gateways one Semantic Model
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
- Datasource01 points to a SQL server which I access via a VPN (On-Prem gateway01)
- 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
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.
3 Replies
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.
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.
