Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi All, I am struggling with the issue of "Cannot convert the value null to type Record".
I am using Businesss central api is to create a report in power bi. I has been working fine from last 2 years and all of a sudden it has started giving this error. This is not letting power bi reports which are connected to business central to refresh.
I have tried multiple solutions but couldn't find the issue.
I do not have any column with null values and done everything to resolve it. I am using a simple query to just fetch the data.
Below is the error
Data source error: Expression.Error: The OData connector failed with the following error: We cannot convert the value null to type Record... . The exception was raised by the IDbCommand interface. Table: Accounts of Sales
Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Time: 2024-09-11 17:25:44Z
Solved! Go to Solution.
Hello @alamp @ZooTV
check this solution
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])
also you can follow the issue to get updated
https://community.fabric.microsoft.com/t5/Issues/The-OData-connector-failed-with-the-following-error...
Proud to be a Super User! | |
Thanks guys for the responses. Managed to resolve for few of the reports but not all. Still looking for permanent solution.
Hello @alamp @ZooTV
check this solution
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])
also you can follow the issue to get updated
https://community.fabric.microsoft.com/t5/Issues/The-OData-connector-failed-with-the-following-error...
Proud to be a Super User! | |
Hi Idris,
thank you for this.
I have sorted the 15 reports I had already in place. However I am trying to set up a new report from scratch and when I try to select the tables from our ERP (Business Central), I got the same error. In this case I cannot open the table and set up the forth value to [UseReadOnlyReplica = null]).
Any idea how to sort it out?
Hi @alamp
thank you for your reply.
I am afraid there is no code yet.
It is blank report where I click in "Get Data", chose "Dynamics 365 Business Central" and then I cannot select any source
I think this also worked and MS has patched the error now. Few of the reports i didn't changed anything and it's working now. Thanks guys.
Hi @Idrissshatila , Thanks for the response. This is has worked for few of my report but not for all. I have raised a case with MS product team as well.
I will update you once i get any permanent solution.
I found this thread, which may shed some light on the problem.
The OData connector failed with the following erro... - Microsoft Fabric Community
I am having the same issue, which appeared 2-3 days ago..
The error is:
"Data source errorExpression.Error: The OData connector failed with the following error: We cannot convert the value null to type Record... . The exception was raised by the IDbCommand interface"
I am able to perform a "Refresh" via the desktop app and re-publish successfully. But the update scheduled within the semantic model continuously fails.
It also seems to failing on different tables each time.
I will keep investigating.
User | Count |
---|---|
36 | |
30 | |
28 | |
25 | |
23 |
User | Count |
---|---|
51 | |
50 | |
33 | |
33 | |
29 |