Forum Discussion
Power BI - Data Gateway Installation Issue
- 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!
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.
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.
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.
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.
