PowerBI Desktop returning 404 getting OData API but works fine in FiddlerWhy calling API in ASP.NET works only if I have Fiddler open?Why would an making my ODataController have a plural name stop it from workingIdentityServer3 access token validation and pre-signed urlCan't get Fiddler to capture HttpClient web api calls from MVC with localhost different portself-hosted WebAPI 2 / OData 4 app - all controllers working, but oneDoes ExtJS's BufferedStore work with an OData REST APIAsp.net Web Api stop using ARRAffinity cookieWhy OData api called multiple times in power bi desktopWeb Service Cannot Connect to API After Fiddler UninstallOdata feed not connecting in PowerBI or Excel
Results relying on higher derived algebraic geometry
What defines a person who is circumcised "of the heart"?
Why "strap-on" boosters, and how do other people say it?
Trouble in mapping of möbius transformation
Make the `diff` command look only for differences from a specified range of lines
Is there any mention of ghosts who live outside the Hogwarts castle?
What pc resources are used when bruteforcing?
Why is a weak base more able to deprotonate a strong acid than a weak acid?
Computing elements of a 1000x60 matrix exhausts RAM
How would a physicist explain this starship engine?
Informal question construction: "Anyone know what...", "Everyone finished?"
Why is this integration method not valid?
What was the primary motivation for a historical figure like Xenophon to create an extensive collection of written material?
why "American-born", not "America-born"?
Nunc est bibendum: gerund or gerundive?
Must every right-inverse of a linear transformation be a linear transformation?
Is a world with one country feeding everyone possible?
Department head said that group project may be rejected. How to mitigate?
Was murdering a slave illegal in American slavery, and if so, what punishments were given for it?
Axiom of Choice in General Topology
Is it safe to redirect stdout and stderr to the same file without file descriptor copies?
What is this dime sized black bug with white on the segments near Loveland Colorodao?
Caught with my phone during an exam
Does science define life as "beginning at conception"?
PowerBI Desktop returning 404 getting OData API but works fine in Fiddler
Why calling API in ASP.NET works only if I have Fiddler open?Why would an making my ODataController have a plural name stop it from workingIdentityServer3 access token validation and pre-signed urlCan't get Fiddler to capture HttpClient web api calls from MVC with localhost different portself-hosted WebAPI 2 / OData 4 app - all controllers working, but oneDoes ExtJS's BufferedStore work with an OData REST APIAsp.net Web Api stop using ARRAffinity cookieWhy OData api called multiple times in power bi desktopWeb Service Cannot Connect to API After Fiddler UninstallOdata feed not connecting in PowerBI or Excel
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have a customers OData feed that I want to pull into PowerBI. When calling the API directly PowerBI works fine using a bearer token
i.e https://api.mywebsite.com/odata/customers
However I route all my traffic through a reverse proxy (a basic url rewrite in the web.config) so all requests actually come through this url:
https://mywebsite.com/api/v1/odata/customers
This reverse proxy url works fine in Fiddler. It reroutes to the first url and also works does this correctly when my UI calls it in the browser. However PowerBI returns a 404 everytime.
I enabled PowerBI trace logs and found 2 errors appearing
"https://mywebsite.com/api/v1/odata/customers"
ExceptionType: System.Net.WebExceptionPublicKeyToken=b77a5c561934e089rn
Message: Unable to connect to the remote server
StackTrace:n at System.Net.HttpWebRequest.GetResponse()rn
at Microsoft.Mashup.Engine1.Library.Common.WrappingHttpWebRequest
Microsoft.Mashup.Engine1.Library.OData.ODataFallbackVersionHandler.
HandleVersionFallbackMessage:
No connection could be made because the target machine actively refused it
127.0.0.1:8888
System.Net.Sockets.Socket.DoConnect
I checked my reverse proxy and web app logs and there are no 404s which suggests its a genuine 404 in the error above, but not sure what the 127.0.0.1 error means?
There are no firewall restrictions on my reverse proxy url as Fiddler works fine to make the call from my local machine. Just PowerBI does not like it, however PowerBI works fine with the direct call to the API. I have tried clearing all the data source permissions in PowerBI to start from scratch, but I am using bearer token auth in the headers anyway so they should not apply.
asp.net odata powerbi powerbi-desktop
asked Mar 23 at 20:36
User101User101
1632421
add a comment |
I have a customers OData feed that I want to pull into PowerBI. When calling the API directly PowerBI works fine using a bearer token
i.e https://api.mywebsite.com/odata/customers
However I route all my traffic through a reverse proxy (a basic url rewrite in the web.config) so all requests actually come through this url:
https://mywebsite.com/api/v1/odata/customers
This reverse proxy url works fine in Fiddler. It reroutes to the first url and also works does this correctly when my UI calls it in the browser. However PowerBI returns a 404 everytime.
I enabled PowerBI trace logs and found 2 errors appearing
"https://mywebsite.com/api/v1/odata/customers"
ExceptionType: System.Net.WebExceptionPublicKeyToken=b77a5c561934e089rn
Message: Unable to connect to the remote server
StackTrace:n at System.Net.HttpWebRequest.GetResponse()rn
at Microsoft.Mashup.Engine1.Library.Common.WrappingHttpWebRequest
Microsoft.Mashup.Engine1.Library.OData.ODataFallbackVersionHandler.
HandleVersionFallbackMessage:
No connection could be made because the target machine actively refused it
127.0.0.1:8888
System.Net.Sockets.Socket.DoConnect
I checked my reverse proxy and web app logs and there are no 404s which suggests its a genuine 404 in the error above, but not sure what the 127.0.0.1 error means?
There are no firewall restrictions on my reverse proxy url as Fiddler works fine to make the call from my local machine. Just PowerBI does not like it, however PowerBI works fine with the direct call to the API. I have tried clearing all the data source permissions in PowerBI to start from scratch, but I am using bearer token auth in the headers anyway so they should not apply.
asp.net odata powerbi powerbi-desktop
asked Mar 23 at 20:36
User101User101
1632421
add a comment |
I have a customers OData feed that I want to pull into PowerBI. When calling the API directly PowerBI works fine using a bearer token
i.e https://api.mywebsite.com/odata/customers
However I route all my traffic through a reverse proxy (a basic url rewrite in the web.config) so all requests actually come through this url:
https://mywebsite.com/api/v1/odata/customers
This reverse proxy url works fine in Fiddler. It reroutes to the first url and also works does this correctly when my UI calls it in the browser. However PowerBI returns a 404 everytime.
I enabled PowerBI trace logs and found 2 errors appearing
"https://mywebsite.com/api/v1/odata/customers"
ExceptionType: System.Net.WebExceptionPublicKeyToken=b77a5c561934e089rn
Message: Unable to connect to the remote server
StackTrace:n at System.Net.HttpWebRequest.GetResponse()rn
at Microsoft.Mashup.Engine1.Library.Common.WrappingHttpWebRequest
Microsoft.Mashup.Engine1.Library.OData.ODataFallbackVersionHandler.
HandleVersionFallbackMessage:
No connection could be made because the target machine actively refused it
127.0.0.1:8888
System.Net.Sockets.Socket.DoConnect
I checked my reverse proxy and web app logs and there are no 404s which suggests its a genuine 404 in the error above, but not sure what the 127.0.0.1 error means?
There are no firewall restrictions on my reverse proxy url as Fiddler works fine to make the call from my local machine. Just PowerBI does not like it, however PowerBI works fine with the direct call to the API. I have tried clearing all the data source permissions in PowerBI to start from scratch, but I am using bearer token auth in the headers anyway so they should not apply.
asp.net odata powerbi powerbi-desktop
asked Mar 23 at 20:36
User101User101
1632421
I have a customers OData feed that I want to pull into PowerBI. When calling the API directly PowerBI works fine using a bearer token
i.e https://api.mywebsite.com/odata/customers
However I route all my traffic through a reverse proxy (a basic url rewrite in the web.config) so all requests actually come through this url:
https://mywebsite.com/api/v1/odata/customers
This reverse proxy url works fine in Fiddler. It reroutes to the first url and also works does this correctly when my UI calls it in the browser. However PowerBI returns a 404 everytime.
I enabled PowerBI trace logs and found 2 errors appearing
"https://mywebsite.com/api/v1/odata/customers"
ExceptionType: System.Net.WebExceptionPublicKeyToken=b77a5c561934e089rn
Message: Unable to connect to the remote server
StackTrace:n at System.Net.HttpWebRequest.GetResponse()rn
at Microsoft.Mashup.Engine1.Library.Common.WrappingHttpWebRequest
Microsoft.Mashup.Engine1.Library.OData.ODataFallbackVersionHandler.
HandleVersionFallbackMessage:
No connection could be made because the target machine actively refused it
127.0.0.1:8888
System.Net.Sockets.Socket.DoConnect
I checked my reverse proxy and web app logs and there are no 404s which suggests its a genuine 404 in the error above, but not sure what the 127.0.0.1 error means?
There are no firewall restrictions on my reverse proxy url as Fiddler works fine to make the call from my local machine. Just PowerBI does not like it, however PowerBI works fine with the direct call to the API. I have tried clearing all the data source permissions in PowerBI to start from scratch, but I am using bearer token auth in the headers anyway so they should not apply.
asp.net odata powerbi powerbi-desktop
asp.net odata powerbi powerbi-desktop
asked Mar 23 at 20:36
User101User101
1632421
asked Mar 23 at 20:36
User101User101
1632421
asked Mar 23 at 20:36
User101User101
1632421
asked Mar 23 at 20:36
User101User101
1632421
asked Mar 23 at 20:36
User101User101
1632421
1632421
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
So turns out I was using OData v3 and the server had OData v4, now its backward compatible but you have to add MaxDataServiceVersion="3.0" to the headers on your request out from PowerBI. PowerBI itself did not let me capture data and inspect through fiddler, however Excel did on the same API.
answered Mar 26 at 13:44
User101User101
1632421
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55318126%2fpowerbi-desktop-returning-404-getting-odata-api-but-works-fine-in-fiddler%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
So turns out I was using OData v3 and the server had OData v4, now its backward compatible but you have to add MaxDataServiceVersion="3.0" to the headers on your request out from PowerBI. PowerBI itself did not let me capture data and inspect through fiddler, however Excel did on the same API.
answered Mar 26 at 13:44
User101User101
1632421
add a comment |
So turns out I was using OData v3 and the server had OData v4, now its backward compatible but you have to add MaxDataServiceVersion="3.0" to the headers on your request out from PowerBI. PowerBI itself did not let me capture data and inspect through fiddler, however Excel did on the same API.
answered Mar 26 at 13:44
User101User101
1632421
add a comment |
So turns out I was using OData v3 and the server had OData v4, now its backward compatible but you have to add MaxDataServiceVersion="3.0" to the headers on your request out from PowerBI. PowerBI itself did not let me capture data and inspect through fiddler, however Excel did on the same API.
answered Mar 26 at 13:44
User101User101
1632421
So turns out I was using OData v3 and the server had OData v4, now its backward compatible but you have to add MaxDataServiceVersion="3.0" to the headers on your request out from PowerBI. PowerBI itself did not let me capture data and inspect through fiddler, however Excel did on the same API.
answered Mar 26 at 13:44
User101User101
1632421
answered Mar 26 at 13:44
User101User101
1632421
answered Mar 26 at 13:44
User101User101
1632421
answered Mar 26 at 13:44
User101User101
1632421
1632421
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55318126%2fpowerbi-desktop-returning-404-getting-odata-api-but-works-fine-in-fiddler%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
