Forum Discussion

keinshah's avatar
keinshah
Helper I
1 year ago
Solved

undefinedPower BI error NULL

Hello community,   I have my data source as MS business central. When I refresh on desktop, it works fine without any errors. However, when scheduled refresh or manual refresh online, it returns th...
Need Help
  • Dejan-Pajk's avatar
    Dejan-Pajk
    1 year ago

    The latest version of the connector no longer permits the 4th parameter to be null.

    Please try the following solution:

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

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

Dejan-Pajk's avatar
Dejan-Pajk
Advocate II
1 year ago

The latest version of the connector no longer permits the 4th parameter to be null.

Please try the following solution:

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

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello Dejan,

 

Thank you for the solution. The original problem for me is the below two error codes:

 

1) Data source error: 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: TableName.

2) Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

<ccon>Expression.Error: The OData connector failed with the following error: We cannot convert the value null to type Record... </ccon>. The exception was raised by the IDbCommand interface. Table: TableName.

 

Since, I have the following:

OData.Feed("https://XXXX.dynamics.com/data/", null, [Implementation="2.0"])

XXXX = Companyname

 

I was trying to replace null with [UseReadOnlyReplica = null] and it is giving below error.

 

Expression.Error: OData: The header with name 'UseReadOnlyReplica' has a value type 'Null' that is invalid. Only DateTime, Logical, Number, and Text are supported.

 

How should we handle this? Could you please help?

 

Thank You and Regards,

Pavan.