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

[Xiaoying]

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 refreshed on desktop version and re-published the report. 

The online scheduled refresh keeps on getting this error and I cannot find a reason in the desktop version since there is no error in desktop.

[Idrissshatila]

@Xiaoying @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]

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

[Henke6373]

After changing this, it all went okay:

Changes:

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

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

[Idrissshatila]

Hello @Xiaoying @Megafix_Hudson @DarrenWright 

I opened an issue with microsoft support to investigate it, you can follow the issue in the link to know the latest update regarding this issue
https://community.fabric.microsoft.com/t5/Issues/The-OData-connector-failed-with-the-following-error...

[Xiaoying]

Thanks, i found the solution yesterday in the forum and already shared with them in the below content.

[Xiaoying]

In addition, the tables are from Dynamics 365 Business Central. I wonder if other connectors have the same error?

[Megafix_Hudson]

Yeah mine are from BC aswell, currently I'm just manually refreshing the report an publishing it. Not ideal and very manual but better than nothing.

[Xiaoying]

The same, I got several reports need to be refreshed twice a day, now have to do it manually... Thanks for your reply!

[Megafix_Hudson]

Yeah im getting this:

[Xiaoying · Accepted solution]

Solved: The latest version of the connector no longer perm... - Microsoft Fabric Community

found a solution here, please try it, hope it helps!

[DarrenWright]

Hi

I started receiving the same error message for Semantic models that have not been changed to months.

The online schedule refreshed the data every night and has been successful until now. If I open the report in the Desktop app it refreshes with no issues.

[Xiaoying]

Solved: The latest version of the connector no longer perm... - Microsoft Fabric Community

Found a solution there!  hope it helps

[Megafix_Hudson]

This worked for me too. Much appreciated 🙂

[DarrenWright]

I am also connecting to BC and there are other posting regarding this issue on this forum.

[Xiaoying]

Thanks for letting me know. hope the error be fixed soon!

[Megafix_Hudson]

I'm getting the same error, started yesterday. Hopefully they fix it soon.

[Xiaoying]

Hi thanks for your reply! Yes this started from yesterday.