Forum Discussion

alamp's avatar
alamp
Frequent Visitor
1 year ago
Solved

We cannot convert the value null to type Record

Hi All, I am struggling with the issue of "Cannot convert the value null to type Record". I am using Businesss central api is to create a report in power bi. I has been working fine from last 2 year...
Need Help
Show and Tell
Idrissshatila's avatar
Idrissshatila
Super User
1 year ago

Hello alamp ZooTV 

check this solution

Have 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 away

Before:
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