I did a bit more work on this. It’s the LineNbr fields that cause the issue so don’t include them in the $select
If you have a look at the meta data for that generic inquiry then you can see that the data type for LineNbr is string and not numeric / integer as you’d expect.
@suemackeown13 Actually, I was doing some research on a different case and I found that there is a known issue with using ARAdjust table in a GI and then viewing this in OData, same error is generated.
It may be that until the fix version is implemented you will need to use something like ARRegister if possible to get this data, if applicable.
I found adding the $select with the names (captions from the Results Grid) of the GI columns resolved the issue
https://<site.com>/OData/<Tenant>/GenericInquiryName?
$format=json
&$select=ReferenceNbr , Field1, Field2, Field3
&$filter=ReferenceNbr eq '1234567'
I was able to resolve my issue by doing the following. In Power BI , I Selected File | Options and Settings | and then Clear Cache. down near the bottom.
I have no idea why that worked, After I did that, Things worked perfectly.
Hi @suemackeown13 ! For this issue I would check to see if there are calculated fields used in expressions which could be throwing an error for a single result or small sub-set of results. I would recommend to simplify the GI results by trimming the results, conditions, or even relations until the GI is able to be loaded via OData and then build back on to it until it is easier to identify which part is triggering the error.
Sometimes I’ve seen something like an expressions which relies on a calculation and can throw a divide by zero error for a single result, which the GI may be able to handle and still display results, but if there are any errors in the GI when attempting to grab over OData this will almost always result in failure.
Hi @suemackeown13 Is that GI is with large dataset ?
If yes, add some conditions at GI and make smaller dataset and check once
Hi. No it is currently only about 4700 records.
Thank you Benjamin. I think that will be the best option, as the GI is quite complex.