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])

keinshah's avatar
keinshah
Helper I
1 year ago

Hi Dejan,

 

I am getting the below error on the same data set starting today. 

 

OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..

 

Any idea how to solve this?

  • pdolan_tapco's avatar
    pdolan_tapco
    Frequent Visitor
    1 year ago

    This means the timeout on the server that you are pulling from is two small or the dataset you are pulling is too large, either limit your query or have your DBA extend the timeout on the server you are pulling from. Or Limit the Number of records and paginate if this is BusinessCentral