By using this website, you agree to our Terms of Use (click here)
Hi,
We have been using Power BI with Odata, but all of a sudden we lost connection and received the attached error message.
Connection still works with our test company but not with the production.
Any idea what may be causing the issue? I have also created a ticket with Acumatica but they said they are backlogged and I don't have much time left to present some reports.
Thank you,
We figured out the problem and wanted to share in case someone else may run into the same issue.
The problem was the Schema Field in one of the GIs (attached). Once we remove the field everything went back to normal. We first un-exposed all the GIs, went back and exposed them one at a time till we found the broken one, then checked each row on Results tab and that is how we figured it out.
Glad you figured it out Taylan. And thanks for reporting back with your solution.
Hi,
We recently had the same Odata issue with Excel reports that successfully ran before they suddenly stopped working, giving a Error 500.
The problem was that someone created a GI with a "." in the name.
The solution was to delete the GI after that everything was working again.