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

Hittheroof24's avatar
Hittheroof24
Regular Visitor
1 year ago

I've had the same happen to me today - absolute nightmare! 

Opened a ticket with Microsoft and they suggested the following (neither of which has resolved the issue) 

- Are you utilizing the latest version of Power BI Desktop to ensure compatibility and feature support?

- The dataset might contain null or empty values that the OData connector cannot process as a Record type. So, are there any null or empty values in the source data? If yes, try to remove these values.

So currently manually updating 30+ reports in preparation for tomorrow morning...

  • 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

      Hi,

      Thanks for the suggested solutions.

      null, null, null , [userReadOnlyReplica = null

      seems to work,

      null, null 

      Doesn't work with my reports.

       

      Any idea why this connector update/ change wasn't communicated? It has a large effect.

      Now I have to update alot of tables in alot of reports.

      Any idea if there will be another update to fix this?

      Or does anyone have a hint on how to change this in a way other thatn opening all tables from all affected reports in the advanced editor and change the first few lines?
      (I'll make a base table with the route to the database and link to this table in all the other tables, like a parameter.
      So that when another update is required I only have to change one table)

       

    • pdolan_tapco's avatar
      pdolan_tapco
      Frequent Visitor
      1 year ago

      Where is the lastest version documentation that tells me this?

    • keinshah's avatar
      keinshah
      Helper I
      1 year ago

      How do I change that and where from please?

      • virakones's avatar
        virakones
        Advocate I
        1 year ago

        In your powerbi desktop report > Transform data > select and highlight your Business Central related query > open Advanced editor > replace the first line as described above > Ok > Close & Apply once updated to all BC related queries

  • keinshah's avatar
    keinshah
    Helper I
    1 year ago

    I did remove all NULL values manually. But still it is not working. Let me know if you manage to solve the issue.

    • pdolan_tapco's avatar
      pdolan_tapco
      Frequent Visitor
      1 year ago

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

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