Forum Discussion
Power BI report server points to Old database when automatic refresh kicks in
Hi Anonymous ,
Based on one of your above response, I tried couple of items and one solution worked but with a little change in the format. I gave my server name in below shown format and the refresh worked both in my PBI Desktop and PBI report server. By this way the scheduled refresh works fine.
Host_name:Port_number/Service_name
One small issue with this is, we have two host names as a failover service and quiet often we do site switches between the two host name. So whenever we do a site switch, I need to manually update the server name refresh the report and upload the updated file into the report server.
Is there a way to include two hostnames to the above format, so that it picks up the anyone one server which is available, I tried a couple of combinations but still did not get it right. Any suggestions will be very helpful.
Also thanks a million for all your suggestions.
Kind Regards,
Mithra
Host_name:Port_number/Service_name is oracle ezconnect , depending on your oracle version you may be able to use ezconnect plus Oracle Database Easy Connect Plus
You may also have more than one tnsnames file on your report server if you have installed both 32 and 64 bit drivers so worth checking out enviromental variables on the server to make sure you are pointing at the correct one
Hi JPM,
Thanks a million for your response. The oracle easy connect plus script accomodating two hostnames is working fine in my Power BI Desktop(may 2020). When I upload the same file into the Power BI report server (may 2020), I am getting an error - ORA-12154: TNS:could not resolve the connect identifier specified. I used the below format and tried few other combinations.
Protocol://host1,host2:port_no/service_name
But still no luck. The Report server is only accepting the one format Host_name:Port_number/Service_name.
Any suggestions will be really helpful.
Regards
Mithra