Redshift - Can't use different users for data sourcers

[felipefrutuoso]

Hi,

we've developed two documents in power BI desktop, each one, with a different user to connect to our redshift cluster. now that we've published this documents, seems like they are sharing the data source, but they aren't. Every time I configure credentials in one, other stops to work.

Anyone had seeing something like that?

Thank you

[v-frfei-msft]

Hi @felipefrutuoso,

Has your issue been solved? If any other question, feel free to let me know please.

Regards,

Frank

[felipefrutuoso]

hey @v-frfei-msft, not yet. I'm making some tries with Azure sqlDW to see wheter a plan from microsoft or not 

as soon as i got something new, I will post here.

thank you!

[felipefrutuoso · Accepted solution]

I did my tests and it is a limitation between PowerBI  and AWS RedShift. With Azure SQL DW it worked fine.

[v-frfei-msft]

Hi @felipefrutuoso,

Please refer to this case to connect one data source by different users.

https://community.powerbi.com/t5/Service/connecting-to-the-same-oracle-database-with-different-user/...

Regards,

Frank

[v-frfei-msft]

Hi @felipefrutuoso,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank