Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Cannot convert value null to type Record in online refresh only but all good in Power Bi desktop

Hi there, I got the error message when refresh online both scheduled and on demand as below. Then I downloaded it to open in desktop and refreshed, it was all good and no error, so I refreshe...
Need Help
Idrissshatila's avatar
Idrissshatila
Super User
1 year ago

Anonymous Megafix_Hudson DarrenWright 

Latest Update This solution here works

Have you tried the fix on the below link? 
https://www.reddit.com/r/PowerBI/comments/1f7yadg/data_conversion_error_on_refresh/

We encountered the same error and by adjusting the 4th parameter on the API call, the problem went away

Before:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)

After:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])

Henke6373's avatar
Henke6373
Frequent Visitor
1 year ago

AFter changing this API call, all went well for 1 month. Now the problem re-occurs. SOmething else has changed?

  • Henke6373's avatar
    Henke6373
    Frequent Visitor
    1 year ago

    After changing this, it all went okay:

    Changes:

    from: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])

    to: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = true])