Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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
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
Hi @ayellet,
Could you share the Fiddler trace please?
Best Regards,
Dale
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |