By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
3
Posts
3
Users
1
Reactions
1,640
Views
December 12, 2021 9:53 pm
hi
Anyone encountered this? i have tried to key in my username and passwords multiple times but i can't seem to log in. I cant refresh the Odata in excel..
Thanks
KS
2 Replies
December 13, 2021 9:04 pm
Your screenshot doesn't look like an OData window to me. Can you paste the OData URL that you are connecting to?
December 15, 2021 2:27 pm
Agree with Tim, I have also found that using the JSON connection instead of odata has been more stable. Also older versions of excel do not support odata in powerquery.
If you want to use ODATA JSON - the format is:
https://yourtenantURL/odata/YourTenant/YourGIName/?$format=json
I have many Excel reports setup using ODATA and Power BI, we have adding the json format has been much more stable.
Online Members
