William Brown on 12 Jul 2018 05:14:43
Create multiple data sources for the same database but using multiple credentials. Allow access to different schemas from same gateway.
- Comments (6)
RE: Allow gateway to connect to multiple schema
this is related to problem : https://ideas.powerbi.com/ideas/idea/?ideaid=76b1e2c1-706b-41fe-a170-4792075bf727&page=2
and is the only workaround for the snowflake role issue
RE: Allow gateway to connect to multiple schema
This would really help. Thanks.
RE: Allow gateway to connect to multiple schema
Same issue here. I have two dozen applications that each has a distinct schema within the same database.
RE: Allow gateway to connect to multiple schema
We have the same issue for our Oracle data sources. Since it throws an error if you use the same instance with different credentials, you have to create an alias for each schema in the tnsnames.ora file, which is work intensive. It should allow data sources with different names to use the same server (instance) name.
RE: Allow gateway to connect to multiple schema
Yes. I am facing the same problem. I cannot add multiple datasources for multiple schemas on the same Oracle instance. Right now I am having to create multiple On-premise gateways on different machines to work around this
RE: Allow gateway to connect to multiple schema
This is a big big issue in our organization. We have hundreds of users connecting to Data Warehouses and Data Marts all with different user IDs. This was not very well planned out from Microsoft.