Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a Oracle 9 Version Data base which can only be accessed and connected to Power BI using ODBC driver (32 bit).
I established connection to Oracle DB using ODBC connector in Power BI desktop and published this report to power BI service. In Power BI desktop manual refresh is working good.
Now I want to update/refresh this published report automatically but I have issues in creating gate way connection - "Connection String"
I don't have idea as of now what to type here in areas
-Connection String
-Authentication Method,
Hi @The8
You need to install Power BI Gateway
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
Hello @aj1973
Thanks for your response.
I already installed Power BI standard gateway but the problem is what exactly connection string means? (For example when I connect to a file/Folder in my PC then I will usually mention folder location in this area but when I connect to Oracle database what should I mention here in this connection string area).
-Also same in Authentication Method , I usually use windows authentication for other type of connection , should I use Oracle DB usename here?
Here you go :
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-manage-oracle
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.