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

poggid's avatar
poggid
Regular Visitor
1 year ago

I'm trying to publish a PBIX from the desktop with the fix applied "[UseReadOnlyReplica = null]", however I'm getting this error...

ServerError_CloudStorageBlobStorageServerException 

when I force a manual refresh in the Power BI Service after the publish.  Any suggestions?

 

OutofSpec's avatar
OutofSpec
Frequent Visitor
1 year ago

I changed "[UseReadOnlyReplica = null]" to "[UseReadOnlyReplica = true]" and was able to get pass that error.

  • poggid's avatar
    poggid
    Regular Visitor
    1 year ago

    That worked. Thank you!

  • Aditi_'s avatar
    Aditi_
    New Member
    1 year ago

    I used this solution and it fixed my issue. Do u think these two [UseReadOnlyReplica = null]" to "[UseReadOnlyReplica = true] can result in different outputs.

    • Dejan-Pajk's avatar
      Dejan-Pajk
      Advocate II
      1 year ago

      Hi Aditi_ , I believe the default value of UseReadOnlyReplica is true; therefore the 'null' or 'true' will result in the same data refresh performance.