Forum Discussion

Mithraveer's avatar
Mithraveer
Frequent Visitor
1 year ago

Power BI report server points to Old database when automatic refresh kicks in

Hi,   We have a on-premise Power BI report server and have hosted a number of power bi dashboards in here. All the PBI dashboards are sourced in a oracle database. Recently we moved to a new Oracle...
"Power BI Report Server"
JPM's avatar
JPM
Frequent Visitor
1 year ago

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 

Mithraveer's avatar
Mithraveer
Frequent Visitor
1 year ago

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