Forum Discussion
mrbonvivant
8 years agoAdvocate I
Power BI Report Server Not Recognizing TNS Names File
On the report server I have the 64-bit Oracle database client installed and I have the TNSNames.ora file updated correctly. I have the SQL Server instance installed on the same machine and can creat...
mrbonvivant
8 years agoAdvocate I
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.
amitsankar
7 years agoRegular Visitor
I am having same issue. I have used the same format what you mentioned earlier. But i am getting same error.
Oracle: ORA-12154: TNS:could not resolve the connect identifier specified