Power BI to Acumatica Connection
I am having errors while trying to connect Power BI to my Acumatica. I am not sure if it is no set up correctly in Acumatica itself or if I am doing it wrong altogether. I have followed a lot of the steps I have found on the web. Some examples of these would be Tim Rodman and Microsoft. The errors I get when I try to log into Acumatica app on Power BI:
- Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an
error: (404) Not Found. (Not Found) OData Version: 4, Error: The
remote server returned an error: (404) Not Found. (Not Found) OData
Version: 3, Error: The remote server returned an error: (404) Not
Found. (Not Found) - Error #2: There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe column 'Created' of the table wasn't found. - There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe key didn't match any rows in the table.
Activity IDc718a6b5-154d-4691-8896-f4a328acf95e
Correlation ID44788a32-ef31-8554-0c50-c5f36aa3f730
Request IDb76f990c-4581-6f0a-4a28-d77115d25747
Status code400
TimeFri Nov 16 2018 09:40:27 GMT-0500 (Eastern Standard Time)
Version13.0.7382.141
Cluster URIhttps://wabi-us-east2-redirect.analysis.windows.net
I get error #2 and #3 when I changed the url to have to the companyName at the end instead of just https://[sitedomain]/odata/. Error #2 url = https://[sitedomain]/odata/[companyname].
Any ideas will help.
Thanks,
ms-office powerbi acumatica acumatica-kb
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
add a comment |
I am having errors while trying to connect Power BI to my Acumatica. I am not sure if it is no set up correctly in Acumatica itself or if I am doing it wrong altogether. I have followed a lot of the steps I have found on the web. Some examples of these would be Tim Rodman and Microsoft. The errors I get when I try to log into Acumatica app on Power BI:
- Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an
error: (404) Not Found. (Not Found) OData Version: 4, Error: The
remote server returned an error: (404) Not Found. (Not Found) OData
Version: 3, Error: The remote server returned an error: (404) Not
Found. (Not Found) - Error #2: There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe column 'Created' of the table wasn't found. - There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe key didn't match any rows in the table.
Activity IDc718a6b5-154d-4691-8896-f4a328acf95e
Correlation ID44788a32-ef31-8554-0c50-c5f36aa3f730
Request IDb76f990c-4581-6f0a-4a28-d77115d25747
Status code400
TimeFri Nov 16 2018 09:40:27 GMT-0500 (Eastern Standard Time)
Version13.0.7382.141
Cluster URIhttps://wabi-us-east2-redirect.analysis.windows.net
I get error #2 and #3 when I changed the url to have to the companyName at the end instead of just https://[sitedomain]/odata/. Error #2 url = https://[sitedomain]/odata/[companyname].
Any ideas will help.
Thanks,
ms-office powerbi acumatica acumatica-kb
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
add a comment |
I am having errors while trying to connect Power BI to my Acumatica. I am not sure if it is no set up correctly in Acumatica itself or if I am doing it wrong altogether. I have followed a lot of the steps I have found on the web. Some examples of these would be Tim Rodman and Microsoft. The errors I get when I try to log into Acumatica app on Power BI:
- Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an
error: (404) Not Found. (Not Found) OData Version: 4, Error: The
remote server returned an error: (404) Not Found. (Not Found) OData
Version: 3, Error: The remote server returned an error: (404) Not
Found. (Not Found) - Error #2: There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe column 'Created' of the table wasn't found. - There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe key didn't match any rows in the table.
Activity IDc718a6b5-154d-4691-8896-f4a328acf95e
Correlation ID44788a32-ef31-8554-0c50-c5f36aa3f730
Request IDb76f990c-4581-6f0a-4a28-d77115d25747
Status code400
TimeFri Nov 16 2018 09:40:27 GMT-0500 (Eastern Standard Time)
Version13.0.7382.141
Cluster URIhttps://wabi-us-east2-redirect.analysis.windows.net
I get error #2 and #3 when I changed the url to have to the companyName at the end instead of just https://[sitedomain]/odata/. Error #2 url = https://[sitedomain]/odata/[companyname].
Any ideas will help.
Thanks,
ms-office powerbi acumatica acumatica-kb
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
I am having errors while trying to connect Power BI to my Acumatica. I am not sure if it is no set up correctly in Acumatica itself or if I am doing it wrong altogether. I have followed a lot of the steps I have found on the web. Some examples of these would be Tim Rodman and Microsoft. The errors I get when I try to log into Acumatica app on Power BI:
- Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an
error: (404) Not Found. (Not Found) OData Version: 4, Error: The
remote server returned an error: (404) Not Found. (Not Found) OData
Version: 3, Error: The remote server returned an error: (404) Not
Found. (Not Found) - Error #2: There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe column 'Created' of the table wasn't found. - There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageThe key didn't match any rows in the table.
Activity IDc718a6b5-154d-4691-8896-f4a328acf95e
Correlation ID44788a32-ef31-8554-0c50-c5f36aa3f730
Request IDb76f990c-4581-6f0a-4a28-d77115d25747
Status code400
TimeFri Nov 16 2018 09:40:27 GMT-0500 (Eastern Standard Time)
Version13.0.7382.141
Cluster URIhttps://wabi-us-east2-redirect.analysis.windows.net
I get error #2 and #3 when I changed the url to have to the companyName at the end instead of just https://[sitedomain]/odata/. Error #2 url = https://[sitedomain]/odata/[companyname].
Any ideas will help.
Thanks,
ms-office powerbi acumatica acumatica-kb
ms-office powerbi acumatica acumatica-kb
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
edited Nov 16 '18 at 14:44
C.J. Hope
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
asked Nov 15 '18 at 14:33
C.J. HopeC.J. Hope
146
146
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
URL # 2 is formatted in the same way that worked for me.
To resolve your problem I would suggest you back up a little and troubleshoot each step along the way.
1) Can you connect to your instance in Power BI and get a list of OData sources?
If you can then your connection string and credentials are correct. If not this is where your issue is.
2) If you create a new query against one of the OData sources listed in (1) does it retrieve the data?
If it does then it suggests to me that your issue is within the query(s) you have created.
Without more details that's the best suggestion I can make.
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
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%2f53321749%2fpower-bi-to-acumatica-connection%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
URL # 2 is formatted in the same way that worked for me.
To resolve your problem I would suggest you back up a little and troubleshoot each step along the way.
1) Can you connect to your instance in Power BI and get a list of OData sources?
If you can then your connection string and credentials are correct. If not this is where your issue is.
2) If you create a new query against one of the OData sources listed in (1) does it retrieve the data?
If it does then it suggests to me that your issue is within the query(s) you have created.
Without more details that's the best suggestion I can make.
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
add a comment |
URL # 2 is formatted in the same way that worked for me.
To resolve your problem I would suggest you back up a little and troubleshoot each step along the way.
1) Can you connect to your instance in Power BI and get a list of OData sources?
If you can then your connection string and credentials are correct. If not this is where your issue is.
2) If you create a new query against one of the OData sources listed in (1) does it retrieve the data?
If it does then it suggests to me that your issue is within the query(s) you have created.
Without more details that's the best suggestion I can make.
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
add a comment |
URL # 2 is formatted in the same way that worked for me.
To resolve your problem I would suggest you back up a little and troubleshoot each step along the way.
1) Can you connect to your instance in Power BI and get a list of OData sources?
If you can then your connection string and credentials are correct. If not this is where your issue is.
2) If you create a new query against one of the OData sources listed in (1) does it retrieve the data?
If it does then it suggests to me that your issue is within the query(s) you have created.
Without more details that's the best suggestion I can make.
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
URL # 2 is formatted in the same way that worked for me.
To resolve your problem I would suggest you back up a little and troubleshoot each step along the way.
1) Can you connect to your instance in Power BI and get a list of OData sources?
If you can then your connection string and credentials are correct. If not this is where your issue is.
2) If you create a new query against one of the OData sources listed in (1) does it retrieve the data?
If it does then it suggests to me that your issue is within the query(s) you have created.
Without more details that's the best suggestion I can make.
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
answered Nov 20 '18 at 16:01
PaulSwPaulSw
211
211
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%2f53321749%2fpower-bi-to-acumatica-connection%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
