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

Riegel7's avatar
Riegel7
Regular Visitor
1 year ago

Exactly the same error here as well with Business Central as the data source.

 

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: xxx

 

I've been doing some testing and I can refresh the report locally in Power BI Desktop which works fine, but I get this error when I publish to the Power BI service? If anyone can suggest anything I'm all-ears...

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

    • Sailor1000's avatar
      Sailor1000
      Frequent Visitor
      1 year ago

      Hi Dejan-Pajk
      It solved my problem. 
      A lot of work know updating all the queries. 
      Do you think Microsoft will fix this? Becouse I created a new dataset for tests, and got the same problem. 
      Thank you!

    • 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