AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica OData wit...
OData Error when Pu...
 
Notifications
Clear all

Questions OData Error when Pulling into Power BI

 
Acumatica OData with Microsoft Excel and Power BI
Last Post by Brett Clark 3 years ago
3 Posts
2 Users
2 Reactions
1,333 Views
RSS
Brett Clark
Posts: 10
 Brett Clark
Topic starter
July 18, 2023 11:22 am
(@bclark)
Eminent Member
Joined: 3 years ago

Hello everyone, 

I'm having trouble loading in data from Acumatica into Power BI using the OData feed. Here is the error I am getting: 

image

I've tried reducing the GI down to bare bones, using no parameters, conditions, getting rid of calculated fields, and nothing has worked. 

I've tried copying the GI and doing it over, with the same error. 

And the weirdest part is I was able to load in the GI via OData the first time I tried, but haven't been able to since. 

Any thoughts? 


Tim Rodman reacted
Topic Tags
OData Error
2 Replies
Dominic Shawhan
Posts: 1
 Dominic Shawhan
July 18, 2023 2:45 pm
(@doshawhan)
New Member
Joined: 3 years ago

Hello Brett,

I have run into a similar issue and I fixed it by clearing the cache in Power BI. See screenshot.

Screenshot 2023 07 18 144437

Reply
Brett Clark
 Brett Clark
(@bclark)
Joined: 3 years ago

Eminent Member
Posts: 10
July 18, 2023 3:39 pm
Reply toDominic ShawhanDominic Shawhan

@doshawhan 

Thanks! I've tried that in the past and just tried again. I am able to now refresh the data from the PBIX file that it had successfully loaded into. 

However, I tried creating a new PBIX file with the same OData link, and it keeps giving me the same error as above. Even after clearing cache. 


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Refreshing Odata GI TAbles in Excel not showing newly created GIs with Expose via OData selected
    3 years ago
  • connecting Acumatica to Google Sheets via Odata feed
    3 years ago
  • Excel Odata - Underlying Connection was closed.
    5 years ago
  • You do not have access to this entity set.
    5 years ago
  • Error for certain users when refreshing data in Excel
    7 years ago
Topic Tags:  OData (6) , Error (2) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 10 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Johnny Tang
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×