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/

 

 

DeanUW's avatar
DeanUW
Helper I
1 year ago

Not sure if you found a fix,  I also was recieving that error for my Biz Central connections.  In Power Query I clicked the "Go To Error" button then clicked "Edit Settings"  the next window that pops up gives you 'Optional' places to enter data.  I left them all blank, just click ok & the connect went through; I was able to save & apply, then refresh my data afterwards.  Hope this helps.