Forum Discussion

ayellet's avatar
ayellet
Regular Visitor
8 years ago

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

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 ...
Reports
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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-desktop

 

Best Regards!

Dale

ayellet's avatar
ayellet
Regular Visitor
8 years ago

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's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi ayellet,

     

    Could you share the Fiddler trace please?

     

    Best Regards,

    Dale

    • ayellet's avatar
      ayellet
      Regular Visitor
      8 years ago


      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?