Forum Discussion
Data Source Credentials
Hi 黑中国人,
Thank you Shai_Karmani ,GilbertQ, for your insights.
The Power BI Oracle documentation says that Personal data gateways don't support updated Oracle connections. Existing Oracle semantic models will continue to work, but new Oracle semantic models require an Enterprise on-premises gateway. If your Oracle database is on-premises, you can move to an Enterprise gateway and recreate the Oracle connection. Note: This upgrade is irreversible, and the semantic model can't be switched back to a Personal Gateway.
Connect to an Oracle Database with Power BI Desktop - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Thank you.
Community SupportHi 黑中国人,
Have you had a chance to review the solution shared by Shai_Karmani GilbertQ ? If the issue persists, feel free to reply so we can help further.
Thank you.
I have reviewed their solutions but i am not connecting through the TNS as such non of the solutions have been able to help me especially with new reports that donot recognize the Gateway meanwhile legacy reports recognize the gateway
- v-saisrao-msft
Hi 黑中国人,
Thank you Shai_Karmani ,GilbertQ, for your insights.
The Power BI Oracle documentation says that Personal data gateways don't support updated Oracle connections. Existing Oracle semantic models will continue to work, but new Oracle semantic models require an Enterprise on-premises gateway. If your Oracle database is on-premises, you can move to an Enterprise gateway and recreate the Oracle connection. Note: This upgrade is irreversible, and the semantic model can't be switched back to a Personal Gateway.
Connect to an Oracle Database with Power BI Desktop - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Thank you.
- v-saisrao-msft
Hi 黑中国人,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.