Forum Discussion
Oracle Connection - gateway config in service
Hello
I have configured my direct query oracle connection within Power BI Desktop which works correctly. I then published my report to apps.powerbi.com...
When i open my report in apps.pwerbi.com it gives me an error "There is no gateway to access the data source Oracle". I have checked my manage data sources and see my connection in there - it connects and shows that it is online - see picture below.
Does anybody know what I am might be missing to get this connection to work?
Thanks
Vineet
Anonymous Direct query is not supported by Personal gateway .
Refer this article -https://community.powerbi.com/t5/Desktop/Personal-Vs-Enterprise-Gateway/m-p/767443 and please close this thread 🙂
13 Replies
Did you sign in the gateway and deployed report ?
Try signing in the gateway on your machine with the same Powerbi account and then publish it . It should be able to map .
Also it would be worth checking how oracle connection is setup. You may have to ensure your powerbi report also uses similar connection . In oracle they use service name setup and not sure how your setup and gateway setup is.
details of the steps i have done:
1. when i first connected to oracle, power bi desktop showed an error message saying the driver was old and it pointed me to a website to download the updated driver - i downloaded and installed the 64 bit version.
2. After installing it, I still got the same error message that the driver was old and I was unable to make a connection to the my oracle DB.
3. I ran the install again and it created a second directory under my oracle directory "C:\oracle\product\12.2.0\client_1" & "C:\oracle\product\12.2.0_client_2". This still did not fix the error.
3. I then saw on stack overflow a recommedation to fix the issue - i followed it for both of the (client_1 & client2) folders in my oracle install - the connection started to work in power bi desktop - i was able to get data from my oracle db.
4. I then got the error on apps.powerbi.com, so I then tried what you suggested above and went into my on-premise gateway (personal mode) and then published the report again - still get the same error message in apps.powerbi.com
Thank you again for your feedback.
Anonymous Are you seeing that there is no gateway on your dataset setting on Power BI service?
Note: I faced a similar issue I had to install PowerBI personal gateway and sign in with Azure ID\POWERBI login same as the tenant and then map the data gateway to fix the issue . For me the gateway for the dataset was not even showing . I also ensured data source credentials matched as in gateway setup .
If you have a gateway configured ,it should show the cluster name below the gateway cluster name
Is this the first time you deployed a report using your Azure ad \Powerbi login ? You had no previous report deployments on the Power BI service ?
- v-yueyunzh-msft
Community Support
Hi , Anonymous
According to my understanding of the gateway configuration data source and the prerequisites for enabling data refresh, I think that after successfully configuring the gateway data source and determining the online status of the data source, one of the steps you need to do is to go to the settings of the dataset, open "Gateway Connection" and select the gateway and data source "Map to" you configured for the dataset, and then you can click apply, and then you can test whether the data refresh is successful:
If you have any other questions about the specific operation, you can also specifically query the detailed description of the steps in this document:
Configure scheduled refresh - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
