Forum Discussion
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 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.
Solved: The latest version of the connector no longer perm... - Microsoft Fabric Community
found a solution here, please try it, hope it helps!
17 Replies
I'm getting the same error, started yesterday. Hopefully they fix it soon.
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.
I am also connecting to BC and there are other posting regarding this issue on this forum.
Solved: The latest version of the connector no longer perm... - Microsoft Fabric Community
Found a solution there! hope it helps
This worked for me too. Much appreciated 🙂
Yeah im getting this:
Solved: The latest version of the connector no longer perm... - Microsoft Fabric Community
found a solution here, please try it, hope it helps!
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.
- Idrissshatila
Super User
Hello Anonymous 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-We-cannot/idi-p/4140532#M109217 - Idrissshatila
Anonymous Megafix_Hudson DarrenWright
Latest Update This solution here worksHave 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 awayBefore:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)After:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])AFter changing this API call, all went well for 1 month. Now the problem re-occurs. SOmething else has changed?
After changing this, it all went okay:
Changes:
from: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])
to: Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = true])
