The OData connector failed with the following error: We cannot convert the value null to type Record

[Idrissshatila]

I faced this issue on Power BI service where I am reading data from business central using Odata connector.

I also saw some posts on community with same issue.

please advice on the below

[JS_UNI4C]

Has this fix been rolled out? I'm still getting an error when trying to connect to the API.

[JCLytle85]

Getting the exact same thing. No service for OData connector. Can't start a new report or refresh/modify existing.

[JS_UNI4C]

You can edit your existing file to correct the refresh but yes, you cannot modify or create a new file without this fix. 

Seems it hasn't rolled out to everyone yet so patience is the name of the game at the moment. This is really bad on Microsofts part. 

[barny_c]

@JS_UNI4C 

May I ask where you are checking to see if the update has been rolled out?

[JS_UNI4C]

https://support.fabric.microsoft.com/en-US/support/

It has been rolled out now and after downgrading my Power BI desktop file, I can once again access the API.

[Henke6373]

Back in september we received the error: "We cannot convert a value of type Record"

This issue was fixed when changing the following:

from: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null) 

to: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])

But since October 8th, the error is back again with a slightly different message:

"Cannot convert value null to type Record to type Logical" in online refresh only but all good in Power Bi desktop.

Now we changed the following:

from: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null,  [UseReadOnlyReplica = null]) 

to: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = true])

But still the error occurs.