Power BI Desktop change HTTPS to HTTP -- getting 503 error code

[ayellet]

I'm trying to connect Power BI Desktop to my OData service (using OData feed)

I use my secured environment - URL include HTTPS.

Power BI resolves my URL and replace the HTTPS to HTTP and I get 503 error code.

I (and my customers) cannot get the data when using Power BI.

any idea how to solve it? How to configure Power BI to use HTTPS without changing it to HTTP?

I saw a few words about it here, but no solution:
https://support.office.com/en-us/article/Access-OData-Feeds-from-Power-Query-82BD48B9-6A2F-4F2A-83C9...

[v-jiascu-msft]

Hi @ayellet,

There could be something wrong with your Server. It works fine in my test.

1. I tried it according to this document.

2. Https works fine as we can see from the snapshot.

Http 503 means Service unavailable. Please check your Server and try the latest version PBI Desktop: 2.52.4921.682 (November 2017)

This article could be helpful: https://docs.microsoft.com/en-us/vsts/report/analytics/using-odata-aggregations-with-power-bi-deskto...

Best Regards!

Dale

[ayellet]

thanks you Dale!

I want to be more clear with my situation:

* OData works great for me when I connect it using HTTP.
* Also when I use rest-client (postman) I can see the data.

* When I connect it to secured environment (HTTPS), I saw that Power BI use HTTP protocol only for $metadata request. for     service document and for specific resource - Power BI use HTTPS protocol.

please see the attached example:
I request specific resource (defects), but when I trace the request (using Fiddler) I saw 2 requests:
the first one - using HTTPS to get the specific resource
the second one - using HTTP to get the metadata

any idea?

thanks
Ayellet

[v-jiascu-msft]

Hi @ayellet,

Could you share the Fiddler trace please?

Best Regards,

Dale

[ayellet]

Hi Dale,

I found the reason for that -  the service document is returning an HTTP link to the metadata document instead of an HTTPS link.

The reason for that is that my server is behind WAF (web application firewall) and load balancer.
so Power BI send HTTPS request, but inside the server, the request contains only HTTP.
I'm using Oligno to build the service document, and this framework use this request (with HTTP ) to build the link to metadata document. 

So my question is - why Power BI need this link?
I already gave the URL to my application in the connection dialog, Why do not use this URL?