I believe this is a bug:
All is good so far.
SAME ORACLE DRIVER(s)
SAME Oracle Server, username, password
DIFFERENT Power BI applications.
Regarding this issue, I would suggest you create a support ticket to get dedicated support.
Best Regards,Qiuyun Yu
From the support ticket I created and worked through, I eventually got this response
"This is a known issue and This is an oracle driver issue. Because of the security models in modern apps/Store apps windows does not allow loading dlls from any folder. "