Connection string - change server adres

[kolodjed]

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.

[Anonymous · Accepted solution]

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.

[lbendlin]

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

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

[kolodjed]

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

[lbendlin]

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