Forum Discussion

kolodjed's avatar
kolodjed
New Member
1 year ago
Solved

Connection string - change server adres

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 Po...
  • Anonymous's avatar
    Anonymous
    1 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.