Same Oracle DataBase - Two different PowerBi files - Two credentials

[GustavoSouza]

I have two different powerbi files, however, they both connect to the same Oracle database, but I still wanted to make each file use a different credential. That's not possible? When I edit a PowerBi and change its credential, it changes that of all other files that use the same Oracle database, even if the files are not even open.

Does anyone know how to help me? Great week to everyone.

[Anonymous · Accepted solution]

@GustavoSouza 

Try edit the permission in the current file, it seems you edited in global permission.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @GustavoSouza ,

the credentials are not saved in the PBIX file, they are saved in your user profile. When the file is deployed on the Power BI Service, you can define separate access data for each file.