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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      In Power BI desktop reports > transform data>
      I can't open the advanced editor when multiple queries are selected. The advanced editor option is greyed out. How do you access the advanced editor with multiple queries selected?

      • virakones's avatar
        virakones
        Advocate I
        1 year ago

        Unfortunately, you will need to edit each query one-by-one as each queries code in advanced editor can be different.