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

[benja]

Hi,

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

Error del origen de datos: Expression.Error: The OData connector failed with the following error: We cannot convert the value null to type Record... . The exception was raised by the IDbCommand interface. Table: Entradas Contabilidad.
URI de clúster: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net
Identificador de actividad: 6ecd12bd-d580-42ee-ae6b-dc9407fb5fe9
Identificador de la solicitud: 03328de0-ed91-0b18-312d-db2c66afce6a
Hora: 2024-09-13 08:47:32Z

Is there any solution?

Thanks!

[Denberends]

Hi. I have the same problem since a few days. Did you find a solution for this? Thanks!

[benja]

Hi @Denberends 

https://community.fabric.microsoft.com/t5/Service/The-OData-connector-failed-with-the-following-erro...

[Anonymous · Accepted solution]

Hi @benja 

This issue has been submitted internally. Please be patient to wait for fixing. If there is any progress, I will update it here.

As a workaround, users may be able manually change the query using the advanced editor

from:

Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)

to:

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

Here are similar cases for your reference:

The OData connector failed with the following erro... - Microsoft Fabric Community

Solved: The latest version of the connector no longer perm... - Microsoft Fabric Community

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SaiTejaTalasila]

Hi @benja ,

On power bi desktop open your report -open transform data and go to View>turn on Column profiler.

Select that table and check each applied steps one by one for any errors or null values in your data/time columns.If you have any nulls in date/time then you have to replace it with somedate.

I hope it will be helpful.

Thanks,

Sai Teja 

[ibarrau]

Hi. It looks like you have an issue in your query definition. Maybe at Table: Entradas Contabilidad. You should open the power bi desktop and refresh the model to check more details of the issue, that will specify the exact table with the problem so you can open the query editor and start checking step by step what can be wrong about a column or transformation.

I hope that helps,