Forum Discussion
Power BI Report Server Not Recognizing TNS Names File
I figured out a more viable workaround since I couldn't get the TNS alias to work. I used the format of HOST":"PORT"/"SERVICE_NAME for the Oracle database and it worked! Luckily this is short enough to use in Power BI Desktop. Hopefully this helps someone out.
Hi mrbonvivant,
I am new to oracle, Could u please explain step by step how you achived this workaround.
i installed oracle client in my system, i tested TNS connection in my system with help of sqlplus, it show connected.
same server is connected in Power BI desktop.
From your example the connection string should be formatted as: Data Source="192.168.12.44:1521/ISPL11GDB".
Hi mrbonvivant,
Thank you, its solved my issue while creating new datasource.
For existing report default it took the Connection string from which i develop in Power BI that i can't change?
But this is workaround you mentioned, because of this we will face any issue(like performance or ect..).
Correct - you can't change the connection string on the report sever once it has been sent from Power BI Desktop. You will need to change the connection string in Power BI Desktop then republish the report.
This connection string naming convention is actually a better option than using the full TNS name. You will acheive the same performance.