Forum Discussion
Connection string - change server adres
- Anonymous1 year ago
Thank you lbendlin
Hi, kolodjed
Your database should not use 127.0.0.1, this address is a loopback address, which will point to the local IP address, which is what you mentioned: 192.168.10.10.
What is the IP address 127.0.0.1 and why is it called localhost? - Ask Leo!
When you upload the report to the Report Server, the Report Server will automatically look for 127.0.0.1, however, 127.0.0.1 refers to the local IP address in the computer network, so the Report Server will recognize it as 192.168.10.10.
The best way is to configure your Oracle database using IP: port number, and then use it in Power BI to connect to your database.After this configuration, the report server will look for the database corresponding to your ip:port number and then access it.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Use the server name (FQDN) instead of the email address.
(Please don't run an Oracle server on your desktop)