Calling API with web or Odata and receiving empty results

[Gabriele_hbto]

Hi everyone,

I am trying to retrieve data from this SAP API using the Web Connector:

https://XXXX.sap.XXXX.XXXX:44300/sap/opu/odata/sap/TAB1/TAB1?$select=Product&$format=json

When I make the call with Postman or open the link in a browser, I correctly get the JSON with all the data. However, when I do it from Power BI, I get nothing. I get this string {"d":{"results":[]}} as if there is no data inside, even though there is.
I have also tried using the OData connector, but I only get the column headers with no rows of data.

Could anyone help me with this please?
It's driving me crazy!

thanks guys

[lbendlin]

Please show how you include the authentication, RelativePath and Query in the Web.Contents call

Web.Contents - PowerQuery M | Microsoft Learn

[Gabriele_hbto]

Thanks, it was an authentication issue, I don't know why but PowerBi was making some mess, I resetted all the credentials and it worked, thanks