Forum Discussion
We cannot convert the value null to type Record
Hello alamp ZooTV
check this solutionHave you tried the fix on the below link?
https://www.reddit.com/r/PowerBI/comments/1f7yadg/data_conversion_error_on_refresh/
We encountered the same error and by adjusting the 4th parameter on the API call, the problem went awayBefore:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)After:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])
also you can follow the issue to get updated
https://community.fabric.microsoft.com/t5/Issues/The-OData-connector-failed-with-the-following-error-We-cannot/idc-p/4145261#M109266
Hi Idris,
thank you for this.
I have sorted the 15 reports I had already in place. However I am trying to set up a new report from scratch and when I try to select the tables from our ERP (Business Central), I got the same error. In this case I cannot open the table and set up the forth value to [UseReadOnlyReplica = null]).
Any idea how to sort it out?
Hi alamp
thank you for your reply.
I am afraid there is no code yet.
It is blank report where I click in "Get Data", chose "Dynamics 365 Business Central" and then I cannot select any source