topic Re: Connection string - change server adres in Report Server

Connection string - change server adres

kolodjed — Mon, 30 Sep 2024 20:19:54 GMT

Hello everyone,

I'm starting my adventure with Power BI. I have the following problem. When preparing a report in Power BI Desktop, the Oracle server address is 127.0.0.1, and when publishing on
Power BI Report Server the address to this server is already different, 192.168.10.10, and unfortunately I cannot access it from Power BI Desktop because this is how Power BI Report Server is configured. When I tried to change Power BI Desktop, it checks the connection every time and the file cannot be saved. I will be grateful for your help.

Re: Connection string - change server adres

lbendlin — Mon, 30 Sep 2024 20:32:30 GMT

Use the server name (FQDN) instead of the email address.

(Please don't run an Oracle server on your desktop)

Re: Connection string - change server adres

kolodjed — Tue, 01 Oct 2024 06:30:41 GMT

The main problem is that the Power BI report server is in-house and cannot be used with FQDN

Re: Connection string - change server adres

lbendlin — Tue, 01 Oct 2024 11:08:24 GMT

Why not? It must have some sort of name that it can be addressed by on the internal network.

Re: Connection string - change server adres

Anonymous — Wed, 09 Oct 2024 04:52:38 GMT

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.