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

GrooveLife's avatar
GrooveLife
New Member
1 year ago

Did you get this solved? I also have a user in my org that is having this issue.

DeanUW's avatar
DeanUW
Helper I
1 year ago

I did not have to downgrade my desktop version.  Go into Power Query in "Transform Data".  Click on the go to error button on the table, then click edit settings.  A new window will appear allowing you to enter 'optional' information.  Leave it blank, just click OK.  This re-established my connection like normal & was able to refresh my data.