Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
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.
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.
Are you able to connect to that DB using some other tool like SQL developer?
from the same machine, you have power BI.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |