Solved: Existing Reports Not Refreshing

Jamaicaj · ‎09-10-2024

Good morning everyone,

Could someone please explain the following error to me? My reports have been updating as intended until this weekend, and there have been no changes in my model:

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: Posted Sales Lines.
Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: dade42b5-8690-42aa-a165-fc787e628aec
Request ID: 74cd8f20-3ee5-4706-9cca-2f933cf9b9b3
Time: 2024-09-10 11:13:23Z

Jamaicaj · ‎09-10-2024

There was no change in my model. I found a solution for this posted on Sunday. There was an update over the weekend that requires a small change in your query for it to refresh.

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

View solution in original post

ZooTV · ‎09-11-2024

Refer to this thread: The OData connector failed with the following erro... - Microsoft Fabric Community

AnkitKukreja · ‎09-10-2024

Hi! @Jamaicaj

There must have been a data change in your model, please try to refresh in Desktop and see which query is failing to find the root cause.

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Jamaicaj · ‎09-10-2024

There was no change in my model. I found a solution for this posted on Sunday. There was an update over the weekend that requires a small change in your query for it to refresh.

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