Calling API with web or Odata and receiving empty results

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