Forum Discussion

Learner_007's avatar
Learner_007
Regular Visitor
3 years ago
Solved

Oracle Connection showing disabled in Online Power Query

Hi Guys   I am working on creating a Oracle database connection in Power BI Service using TNS details in the format Hostname:Port/SID in Server Text Box   I am getting all the options as "None" f...
Dataflow
Need Help
Tutorial Requests
  • ibarrau's avatar
    ibarrau
    3 years ago

    Hi. Oracle sources must use a Data Gateway in order to be configured correctly. The screenshot you are showing it is asking you to add the source for an specific gateway. You must install a gateway in a VM or somewhere to help with the data connection and future schedule refresh. Once you add the server, pick the gateway and set the credentials. Then you will be able to connect to the source.

    Keep this link as reference for errors: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-manage-oracle

    I hope that helps,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
3 years ago

Hi. Oracle sources must use a Data Gateway in order to be configured correctly. The screenshot you are showing it is asking you to add the source for an specific gateway. You must install a gateway in a VM or somewhere to help with the data connection and future schedule refresh. Once you add the server, pick the gateway and set the credentials. Then you will be able to connect to the source.

Keep this link as reference for errors: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-manage-oracle

I hope that helps,