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 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-6868BA1D30E2

Reports

4 Replies

  • 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