cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianclarito Frequent Visitor
Frequent Visitor

DMTS_DuplicateDatasourceError in Power BI Gateway ( Data Source Teradata )

Hi Team,

 

Good day! I have reviewed some threads here and need a second opinion about my situation w/ registering servers in Power BI Gateway.

 

We have a Power BI Gateway connecting to a Teradata database cluster. There are multiple teams with their own space/database in that cluster and the plan was to register a data source for each team in the Gateway to control data exposure.

 

I did check the following threads below and what they say is that we can have a limited set of entries for one database - e.g. IP address = 1 entry , hostname = 1 entry. Outside of using ODBC or setting up another Gateway, would any of you have an alternate solution?

https://community.powerbi.com/t5/Service/Need-to-create-Multiple-data-sources-for-different-users-of...

https://community.powerbi.com/t5/Desktop/DMTS-DuplicateDatasourceError-Oracle-DataSource/td-p/149553

pbi-test.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DMTS_DuplicateDatasourceError in Power BI Gateway ( Data Source Teradata )

Hi ianclarito,

 

We can't add a same data source twice in a data gateway cluster. If your need is to control the security level in your report, I would recommend you to configure RLS, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-rls.

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: DMTS_DuplicateDatasourceError in Power BI Gateway ( Data Source Teradata )

Hi ianclarito,

 

We can't add a same data source twice in a data gateway cluster. If your need is to control the security level in your report, I would recommend you to configure RLS, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-rls.

 

Regards,

Jimmy Tao

View solution in original post

ianclarito Frequent Visitor
Frequent Visitor

Re: DMTS_DuplicateDatasourceError in Power BI Gateway ( Data Source Teradata )

Thanks

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 278 members 3,024 guests
Please welcome our newest community members: