Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My report connects to an oracle database via an ODBC connection on the gateway server.
this is due to security reasons, the oracle db will only allow a single firewall exception, so we chose the gateway server.
My question is regarding credentials, i have to set them in the power query data source settings in power bi desktop. I cannot set them in the dataset settings in the power bi service.
Is it possible to pass in odbc credentials via the power bi dataset settings in the power bi service?
Solved! Go to Solution.
No you need to add the source to the Gateway in the service
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
No you need to add the source to the Gateway in the service
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thanks for the reply @aj1973
I can see this when I view the gateway connection options for the data source.
I can also see a connection in the gateway connections section called ODBC Con.
If i update the username & password in this connection, will the report use the new credentials?
The source is not ODBC, it is Oracle. You need to add Oracle in the Gateway like I showed you in the image.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
The source is ODBC.
I cannot connect directly to the Oracle server as the vendor wont open the firewall to the IP ranges.
Instead I created an ODBC connection to the oracle from a VM wtih a static IP, and the Vendor opened the firewall for this single IP.
I can see this connection in the connections list and connect to the data source.
Its not ideal, but it is necessary.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.