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

JS_UNI4C's avatar
JS_UNI4C
Helper I
1 year ago

Microsoft supposedly rolled out a fix yesterday but I am still getting an error when trying to connect to the Business Central API. Note: This is not for an existing file where I can edit the URL. This is for a NEW connection so I am currently stuffed. 

 

Any suggested solutions?

 

https://support.fabric.microsoft.com/en-US/support/

 

 

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.

  • JS_UNI4C's avatar
    JS_UNI4C
    Helper I
    1 year ago

    Yeah, downgrading the desktop app to the old version sorted the problem out. You have to manually download it off Microsoft website, uninstall current version and then install the old version. Connected to API perfectly. 

  • 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.