Forum Discussion
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
- DekuSuper User
Think you need to replace localhost with your IP address
- anoooFrequent 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-priyankataCommunity 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.