Forum Discussion
undefinedPower BI error NULL
- 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])
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/
- GrooveLife1 year agoNew Member
Did you get this solved? I also have a user in my org that is having this issue.
- JS_UNI4C1 year agoHelper I
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.
- DeanUW1 year agoHelper I
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.
- DeanUW1 year agoHelper I
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.