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

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)