how to add same DB as different source with different schemas in PowerBI

[AOD]

Hi All, 

how to add same DB as different source with different schemas in PowerBI

[Arul]

@AOD ,

Can you explain it in detail?

[AOD]

Hi, sorry for not being clear. 

I have a database under which I have 2 schemas. Both these schemas have different credentials. 

I wanted to add both schemas tables in my powerBI report. I added 1st schema point to Database and it connects fine, however, when I try to add new source and point to add 2nd schema same database, it ask me to change the credential. due to which I cannot refresh 1st schema tables. Is there any way I can point to 2 different schemas within same Database ? 

Thanks.