Error

dmonzon Shivu-2000 

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

Hi dmonzon 
The error indicates that Power BI is trying to convert a null value to a complex data structure (a Record) for a table named "HistLinIntervencionQUERYsoloRecursosYreparaciones."

Following could be work arounds available.

• Identify the Null Value:

  • Investigate Data Model: Look at your Power BI data model for the "HistLinIntervencionQUERYsoloRecursosYreparaciones" table. Identify the specific field causing the null value issue.
  • Examine OData Schema: Check the OData service schema to determine if the problematic field is marked as required.

• Address the Null Value:

  • Modify OData Service (if possible): If the field is optional in the OData service, modify the service to return a default value instead of null for that field.
  • Handle nulls in Power BI: Update your data model to handle null values gracefully. Options include:
    • Using conditional logic in DAX formulas to account for nulls.
    • Creating a separate "null flag" field to indicate the presence of null values.

• Verify Data Type Mapping:

  • Compare Data Types: Ensure that the data types in your Power BI data model accurately reflect the data types in the OData service.
  • Adjust Mappings: If mappings are incorrect, adjust them in Power BI to ensure compatibility.

If these aren't helpful, can you provide the sample data.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!

Thank you for your quick response. But when I update in PowerbiDesktop I don't have any errors. I only have it when I post it.

Hello dmonzon ,

I faced the same issue today, while the report was running normally for months.