Forum Discussion
Unable to get new Oracle Database connection information
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!
5 Replies
- amitchandak
Super User
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 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.
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.
