Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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

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

Idrissshatila_0-1725881101279.png

 

Status: Accepted

Hi all , 

Microsoft Fabric Support and Status | Microsoft Fabric

According to feedback on Microsoft Fabric support, the issue will have a fix deployed by the Mid to late September.
The current solution is: Customers will need to manually modify the query in the Advanced Editor by adding a record as the last parameter. Change the query from: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null) to: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = true])

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
JS_UNI4C
Helper I

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

 

JS_UNI4C_0-1726584018717.png

 

JCLytle85
New Member

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

JS_UNI4C
Helper I

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
New Member

@JS_UNI4C 

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

 

 

JS_UNI4C
Helper I

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
Frequent Visitor

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.