Error selecting my gateway

[AlexDXCC]

Hi all,

I want to add my gateway that is connected to an Oracle database but it throws error.

 Updating Media

[v-binbinyu-msft]

Hi @AlexDXCC ,

1. If you connect Oracle Database with Import connection type, please try to install Standard Gateway

2. To connect to an Oracle database with the on-premises data gateway, download and install the 64-bit Oracle Client on the computer running the gateway. The Oracle client software you use depends on the Oracle server version, which always matches the 64-bit gateway.

3. After you install the client and configure ODAC properly, use Power BI Desktop or another test client to verify correct installation and configuration on the gateway.

4. Add data source to use with the gateway

For more details, you can read related document: Manage your data source - Oracle - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexDXCC]

I already have my Oracle client installed, and I installed the "Gateway (personal)" as Power BI Service was saying .
I can see all the data correctly on Power BI Desktop, but I'm not available to add the gateway when I have it ready, I can't understand what is the problem.

[v-binbinyu-msft]

Hi @AlexDXCC ,

If you are using Personal Gateway, please try do below steps in Power BI Service Portal:

1. click "Settings" for the dataset that you want to configure

2. click "Edit datasource credentials", edit the credentials for the personal gateway

3. click "Gateway connection", select the personal gateway you want to use and click apply

4. then you could refresh the dataset with gateway

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.