When accessing a GI through OData in PowerBi or Excel, I get the following error message:
DataSource.Error: We couldn't parse OData response result. Error: Unexpected end of file has occurred. The following elements are not closed: feed. Line 6, position 120.
Details:
DataSourceKind=OData
Does anyone know what this means, and how this can be solved?
Best answer by BenjaminCrisman
Hi
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.
+19Hi
If yes, add some conditions at GI and make smaller dataset and check once
+4Hi
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.
+4It 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 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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
