Forum Discussion
Oracle COnnection error in PBIRS
Oracle Client - 64 Bit is installed on PBIRS. Able to run SQLPLUS from command line and tnsping also works. However creating a data connection fails with the error GUI Error The report serve...
It's Solved same Issue for me.
This issue we can't fix in Power BI Server, we need to fix this in Power BI Desktop itself, because we can't change the datasource in Power BI server once we published from Power BI Desktop, in power bi server only user name and password we can give and datasorce connection string we can't change in it.
So while creating your Power BI report in Power BI desktop, kindly provide your connection sting like this "HOST: PORT/SERVICE_NAME"(Don't give any space) instead of your oracle TNS Service Name.
It's Worked for me, i think so it will be helpfull for you guys also.
Hi,
I have used the connection string as HOST: PORT/SERVICE_NAME; but i am still getting TNS error. Can someone please help kskarthick