Forum Discussion
OData Query Failing with "invalid reader state exception' error while Processing the request
while trying to query an OData feed from Project Server on Prem application, getting an error as below DataFormat.Error: We detected an invalid reader state 'Exception' when processing request 'h...
Hi NeilSingh,
Could you please offer below information:
- What data source you want to connect?
- What is your connection mode?
- Could you have checked the crenditial when you connect to your data in Desktop and which crenditial you have chosen?
Regards,
Daniel He
Hi v-danhe-msft
Please see the responses Inline
Could you please offer below information:
- What data source you want to connect? [Neil] Its an OData feed from Project Server 2013, OOB Provided by Application
- What is your connection mode? [Neil] Using Windows Account to authenticate
- Could you have checked the crenditial when you connect to your data in Desktop and which crenditial you have chosen?[Neil] Yes i can access the data from source and can see data from other tables(hence authentication should not be an issue, also as in snapshot you could see i can browse the OData feed in IE for same tables), this error happens on 2 tables only in Power BI, when i select them as OData source for adding to the report
Let me know if you need any other Information
I am having the same problem and really could use some help on this..
