Unable to get new Oracle Database connection information

[Anonymous]

I have such a case:

1.  All can work well before Oracle database connection string change.

2. Because DB change, so updated tnsnames.ora file with new DB info.

3. Open Power BI desktop, same pbix, refresh the report, unable to read the new DB info.

Even no help after reinstalling the power bi desktop, restarting laptop etc. Not know where there is still cache,  any idea what I still can try? Thanks!

[Anonymous · Accepted solution]

I finally fixed the issue found in my colleagues' power Bi desktop, the problem is not within PB like having cache etc as what I had thought early, just the tnsnames.ora has something wrong. 

[Anonymous]

@amitchandak 

yes, I have that and able to connect. actually in my power bi desktop, this issue gone, other two colleagues still have the problem, before the DB change, all worked in their side. 

I didn't do anything except that .ora file, and they also updated same but still can't work. 

[Anonymous]

@amitchandak 

Thank you to help check! 

I red those two posts, mine is a little different.  Before making DB change all work well,  this only DB server host change,  and no error like what they got  when refreshing the report just still read old DB info. Seems some cache somewhere, but I have no idea where. 

[amitchandak]

Are you able to connect to that DB using some other tool like SQL developer?

from the same machine, you have power BI.

[amitchandak]

Hope you have checked

https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-Oracle-Database/td-p/616774

https://community.powerbi.com/t5/Desktop/Connect-To-Oracle-Database/td-p/188217

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601