Forum Discussion
Solved
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 V...
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.