Solved: Same Oracle DataBase - Two different PowerBi file...

GustavoSouza · ‎06-02-2020

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 · ‎06-03-2020

@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.

View solution in original post

Anonymous · ‎06-03-2020

@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 · ‎06-02-2020

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials