OData: Request failed: Unable to connect to the remote server"

[Anonymous]

Power bi cant connect to odata service (the service is in a kubernetes cluster). It has no passoword and as far as i know no restrictions. the odata link is someting like:

http://<IP>:<port>/odata/Published_OData_service/v1 

Can someone point me in the right direction?

[Syndicate_Admin]

Hello! I need help, I try to connect to a SharePoint file and I get this message, I already delete the permissions and I still get the same error. What should I do?

[v-eachen-msft]

Hi @Anonymous ,

1. You could clear permissions in the global permissions and connect to odata again.

2. Did it show any error code ( like "500","404","415",etc. )?

You could enable the desktop trace log files and check the detail error messages when you connect to Project Online.

[Anonymous]

Facing the same issue. The request, when copied from PBI Desktop form and pasted into the browser, works perfectly.

There are no cached credentials, local or global, in PBI Desktop. Backend is Azure DevOps server 2019.1

What could be the reason?

[amitchandak]

@Anonymous , refer id this can help

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/create-quick-report-odataq?view=azure-devops

https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/?gclid=EAIaIQobChMIy_f6j8G16QIVkX4rCh3rlQyYEAAYASAAEgL0IPD_BwE