Forum Discussion

anooo's avatar
anooo
Frequent Visitor
1 year ago
Solved

Web service Localhost - Powerbi Service

Hello, 

 

I have local web service with an authentication token. I a am abl to load data successfully in powerbi desktop, but i connot update the ata in powerbi service, even fater insatlling the personal mode data gateway.

 

Has anyone encountered this issue our can provide guidance on how to resolve it ? any help would be greatly appreciated 

 

 

  • Hi anooo 

    After replacing localhost with your machine’s IP address, if you still encounter issues, there are additional steps required for Power BI Service to connect successfully:

    Ensure your web service is running and listening on the IP you used. Test it by opening the URL in a browser from a different device on the same network. If that fails, it means your service isn't reachable externally.

    Make sure your firewall allows inbound traffic on the port used by the web service.

    The machine where you installed the Personal Mode Gateway must  be always on and have access to the IP/URL of your web service. Be able to call the API successfully independently of Power BI Desktop.

    Power BI Service does not allow dynamic Web.Contents() calls to fetch tokens at runtime. Instead use a static token if possible or pre-generate the token and store it in a secure location like Azure Key Vault or a local config.

     

    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.

6 Replies

  • Deku's avatar
    Deku
    Super User

    Think you need to replace localhost with your IP address

    • anooo's avatar
      anooo
      Frequent Visitor

      Hello Deku, Thank you. I replaced "localhost" with my IP address, but I am getting this error message in Power BI Service: "Unable to connect to the remote server. Thanks

      • v-priyankata's avatar
        v-priyankata
        Community Support

        Hi anooo 

        After replacing localhost with your machine’s IP address, if you still encounter issues, there are additional steps required for Power BI Service to connect successfully:

        Ensure your web service is running and listening on the IP you used. Test it by opening the URL in a browser from a different device on the same network. If that fails, it means your service isn't reachable externally.

        Make sure your firewall allows inbound traffic on the port used by the web service.

        The machine where you installed the Personal Mode Gateway must  be always on and have access to the IP/URL of your web service. Be able to call the API successfully independently of Power BI Desktop.

        Power BI Service does not allow dynamic Web.Contents() calls to fetch tokens at runtime. Instead use a static token if possible or pre-generate the token and store it in a secure location like Azure Key Vault or a local config.

         

        If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
        Thank you.