Power BI - Data Gateway Installation Issue

[RPBI1]

Hello , First time I am installing Data Gateway using service account and personal account (personal data gateway), both times I am stuck with same place , please see screenshot. I have masked service account email id.  How do I resolve this issue.

thank you

[v-karpurapud]

Hi @RPBI1 

Just checking in as we haven't received a response to our previous message. Were you able to review the information above? Let us know if you have any additional questions.

Thank You.

[RPBI1]

Hello, I went with default region and registed my gateway, now I am trying to create new connection getting following error.

In Data Gateway VM server , I have installed Oracle client and able to connect to the database using SQLPlus and I was able to create Power BI dashboard using same credentials on the Data Gateway VM server. Since I was able to connect to the database in powerbi I didn't installed ODAC drivers.  Should I install ODAC driver?

thank you

[v-karpurapud]

Hi @RPBI1 

Yes, you need to install the Oracle ODAC (Oracle Data Access Components) package on the gateway machine. Being able to connect through SQL*Plus or Power BI Desktop only confirms that a basic Oracle client and network connectivity are working. The on-premises data gateway additionally requires the Oracle provider components, including OraOLEDB.Oracle, to be properly installed and registered.

From the error message, it appears the required Oracle provider is either missing, not registered correctly, or incompatible with the current setup. Please install the 64-bit ODAC package and ensure it includes both Oracle Data Provider for .NET (ODP.NET) and Oracle Provider for OLE DB (OraOLEDB.Oracle). Also verify that the Oracle client and ODAC versions are compatible, then restart the On-premises Data Gateway service and try creating the connection again.

For reference:
Connect to an Oracle Database with Power BI Desktop - Power BI | Microsoft Learn

If you have any other questions, feel free to contact us. We're here to help.

Regards,

Microsoft Fabric Community Support Team.

[RPBI1 · Accepted solution]

Hello, thank you for following up. I was able to successfully install the Oracle and ODP.NET drivers, and I can now establish a connection and use the Data Gateway. Thank you for your support throughout this process!

[RPBI1]

thank you for your reply.

I was able to install data gateway, I hade to open two new firewall to reach internet from my VM server.  I have successfully installed , below attached screenshot. But I can't view in the data gateway I created , what am I doing wrong.

[v-karpurapud]

Hi @RPBI1 

Thank you for the update. With the gateway now installed and showing as online, the current issue is that Power BI Service is not detecting a compatible gateway connection for your dataset.

This may be due to the Power BI account being different from the one used to register the gateway, the gateway not having a configured datasource or connection, a mismatch between the dataset connection details and the gateway datasource settings, or the user lacking permission to access the gateway or datasource.

Since the gateway is online locally, please check if it appears in Power BI Service under Settings > Manage connections and gateways, and make sure the current user has access.

For most on-premises gateway setups, a datasource or connection should be added to the gateway that matches the dataset connection details, including the server name, database name, and authentication method.

If a different account owns or manages the dataset, please ensure that user has permission to use the gateway or datasource, such as being added as a datasource user or gateway admin.

Once these checks are complete, go back to the dataset settings to see if the gateway appears under the Gateway and cloud connections section.

Reference: Add or remove a gateway data source - Power BI | Microsoft Learn

I hope this helps. If you have any other questions, feel free to contact us. We're here to help.

Regards,

Microsoft Fabric Community Support Team.

[RPBI1]

1. "This may be due to the Power BI account being different from the one used to register the  gateway" :  That is true, I have configured this gateway in the VM server using "xyz" service account. As a user I am logging to app.powerbi.com and trying to access below gateway I created but I can't see . How to fix this issue. 

2. In the below screen , Microsoft Fabric is showing not available after Data Gateway registration , would that be an issue?

3. How to check if my user Id has permissons to access registered data gateway 

thank you.

[v-karpurapud]

Hi @RPBI1 

Thank you for clarifying. The behavior is now understandable.

The gateway was registered with the xyz service account, but you're using a different account to access Power BI Service. Gateways in Power BI aren't automatically visible to other users unless permissions are set.

Log in to Power BI Service with the xyz account or ask the gateway administrator to update your access. Go to Settings > Manage connections and gateways, select the gateway, and check that it's Online.

Add your current user account as a Gateway admin or Connection/Datasource user. If your account isn't listed, the gateway won't appear in your dataset settings.

For most on-premises gateway scenarios, make sure the datasource/connection under the gateway matches the dataset connection details exactly, including server name, database name, and authentication method.

Once permissions and datasource mapping are set, sign out and back into Power BI Service, then check the Gateway and cloud connections section in your dataset settings again.

Regarding “Microsoft Fabric – Not available” message in the gateway app isn't related to this issue and doesn't affect normal Power BI gateway use or dataset refresh. It concerns Fabric/Power Platform environment support and can be ignored here.

If you have more questions, please reach out and we'll help.

Regards,

Microsoft Fabric Community Support Team.

[RPBI1]

Thank you so much , steps you have provided worked , once I login to app.powerbi.com using xyz service account , I can see the data gateway I created, there I was able to add myself to the data gateway .  And when I login to app.powerbi.com as me I am able to see the data gateway connection.  So thank you so much. 

I have noticed something with Region I picked while installing the gateway. Please see step 1 and 2. 

step 1. when I selected "East US" in the region , Microsoft Fabric is not available and I was not seeing Data Gageway I created in app.powerbi.com

step 2. when I left default region which is "Australia Southeast" region , Microsoft Fabric is available and I am seeing Data Gageway I created in app.powerbi.com

my question: Is there permission issue in the region that was assigned to me which "East US" region ?

[v-karpurapud]

Hi @RPBI1 

Thanks for providing the screenshots and details. This issue is usually related to tenant and region alignment, not permissions for the “East US” region. The main difference is how Microsoft Fabric environments and gateway registrations connect to tenant regions.

When you chose East US, the gateway displayed “Microsoft Fabric – Not available” with the message “Can’t be used outside your default environment.” This indicates the gateway region doesn’t match your tenant’s default Power BI/Fabric region or assigned Fabric environment, so Fabric features aren’t enabled for that gateway registration.

Using the default region (Australia Southeast), the gateway matched your tenant environment, which made Microsoft Fabric available and showed the gateway in Power BI Service. Microsoft documentation states cross-region gateway scenarios aren’t supported, so the gateway region should match your tenant’s default Power BI/Fabric region for proper visibility and functionality.

For detailed guidance, please refer to Set the datacenter region for the on-premises data gateway | Microsoft Learn  and community discussions such as Solved: Fabric Data Gateway in Non-Default Region - Microsoft Fabric Community

I hope this clarifies things. If you have any other questions, feel free to ask. We're here to help if needed.

Regards,

Microsoft Fabric Community Support Team.

[v-karpurapud]

Hi @RPBI1 

Hope you're doing well. We wanted to check if your query has been resolved with the solutions provided. If it's still pending, please let us know any further details so we can help.

Thank You.

[RPBI1]

Hello,  When I created Data Gateway called "DG East" using "East ABC" region , I am not able to see data gateway when I login to app.powerbi.com however when I login to https://admin.powerplatform.microsoft.com/ I can see "DG East". On that data gateway "DG East" I pro...

And then when I created Data Gateway called "DG sw" using "Southwest ABC" region , I am able to see data gateway when I login to app.powerbi.com and  to https://admin.powerplatform.microsoft.com/ 

And when I login to app.powerbi.com -> ? then go to ->About Power BI

Your home region =Southwest ABC

1. I thinking my power bi home region is Southwest ABC that is why I don't see gateways created using "East ABC" region . My understanding is correct.

2. How to change Power bi home region to "East ABC"  region.  Because my admin created work space using capacities created in "East ABC"  region.

thank you

[v-karpurapud]

Hi @RPBI1 

Your understanding is mostly correct. Power BI gateways are linked to your tenant’s home (default) region, which you can find under About Power BI. Since your home region is Southwest ABC, gateways registered in that region are usually fully visible and supported in app.powerbi.com.

Gateways from other regions, like East ABC, may show up in the Power Platform Admin Center but might not appear properly or work fully in Power BI/Fabric due to region and environment limitations.
The Power BI home region can’t be changed at the user level or directly in Power BI. It’s set by your Microsoft 365 / Power BI tenant setup, and changing it would require a tenant-level migration coordinated by admins and Microsoft Support.

So, it’s best to register and use gateways in the same region as your Power BI home region for reliable visibility and functionality, even if some resources are in other regions.

Regards,

Microsoft Fabric Community Support Team.

[v-karpurapud]

Hi @RPBI1 

Thank you for contacting the Microsoft Fabric community forum.

When installing or registering the on-premises data gateway, you must sign in using a valid Microsoft Entra ID (Azure AD) work or school account.Thank you for contacting the Microsoft Fabric community forum.

A service principal (non-interactive identity) cannot be used for the initial gateway registration, as the setup requires interactive authentication. However, a service account (regular user account) can be used as long as it can sign in interactively.
 

Based on the screenshot, since the issue occurs during sign-in, it may not be related to the account type alone. The gateway sign-in experience uses the Microsoft Edge WebView2 runtime, so authentication issues can sometimes be related to cached credentials or local environment configuration.

You can try the following checks:

Ensure you are using a valid work/school (Entra ID) account (not a personal Microsoft account).

Try signing in using an InPrivate window or a different Windows user profile.

Clear cached credentials (Credential Manager / browser cache).

Ensure the Microsoft Edge WebView2 runtime is installed and up to date.

Check for network or proxy restrictions that may block authentication endpoints.

After the gateway is successfully installed, service principals can be used in supported Power BI/Fabric automation scenarios through Power BI Service or REST APIs.

References:

Install an on-premises data gateway

Troubleshoot Power BI gateway (personal mode)
Solved: Configuring an On-Premises Data Gateway Using a Se... - Microsoft Fabric Community

I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.

 

Regards,

Microsoft Fabric Community Support Team.