Forum Discussion

Noobie's avatar
Noobie
Frequent Visitor
2 years ago

PBI Refresh (OLE DB or ODBC error: [DataSource.Error] Oracle: ORA-12514: TNS:listener does not curre

Hi all,   Issue: PowerBI Refresh button needs to be clicked twice to finish refreshing.   I've been battling with this issue PowerBI Refresh button issue since Jan 2024. None of us had a clue as ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Noobie 

 

Make sure that the Oracle listener is properly configured to recognize the service name defined in the file. You can do this by inspecting the file on the Oracle database server and making sure that it contains entries for the service that Power BI is trying to connect to. More details on configuring listeners.


Since you mentioned that the TNS files are in the correct folder and location, double-check that the environment variables are correctly pointing to the directory that contains your files. This ensures that your Oracle client can find the file.


For more detailed guidance on troubleshooting Oracle connectivity issues in Power BI, including managing on-premises data gateways, see the following documentation:

 

Manage your data source - Oracle - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Noobie's avatar
Noobie
Frequent Visitor
2 years ago

Hi Yongkang,

Thanks so much for your help! 

My TNS file is 100% error free as my teammates been using it eversince and my environment variable is correct too. I think it must have been because of application itself which I cannot find anything about how to resolve this.