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

Hi Pavan,

 

The solution mentioned above applies only to the Power BI connector (Dynamics365BusinessCentral.ApiContentsWithOptions), not to OData.Feed.

Therefore, replacing null will not resolve the issue with the OData.Feed connector.

 

You can find more documentation about OData here:
https://learn.microsoft.com/en-us/power-query/connectors/odata-feed 

 

Below is an example that connects to Business Central web services:

 

OData.Feed("https://api.businesscentral.dynamics.com/v2.0/11111111-1111-1111-1111-111111111111/Sandbox/ODataV4/Company('Company Name')", null, [Implementation = "2.0"])

(replace 11111111-1111-1111-1111-111111111111 & Company Name)

 

Best regards,
Dejan

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you very Dejan, will try that