Can't save dataflow due to cdsaModelvalidationfailed error message

Hi hugosilvasilva 

Thank you for reaching out to the Microsoft Fabric Community Forum. 

The answer provided by GilbertQ  was indeed correct. In addition to that, I am including some more points that might help.

The error CdsaModelValidationFailed occurs due to issues with the validation of the dataflow model, often caused by incompatible data types, missing required fields, or schema inconsistencies.

To troubleshoot and resolve this issue, please follow these steps:

1. Check Data Consistency:

• Ensure that the column names in the new table do not have unsupported characters or duplicate names.

2. Metadata Inconsistencies:

• Custom tables might have schema conflicts or metadata misalignments. Ensure that metadata, such as table relationships or column properties, aligns with Power BI's expectations.

3. Model Validation:

• Ensure that your data model is valid and free of hidden issues. Even if Power Query shows no warnings, there might be underlying issues with the data model that need to be addressed.

4. Refresh and Retry:

• Refreshing the workspace or reloading the dataflow after making changes can often resolve temporary issues related to caching or syncing.
• Additionally, custom tables might encounter issues if the dataflow has advanced features like linked entities or DirectQuery storage.

If the issue persists after these steps, please share the detailed logs or configuration for further debugging.

If my response has resolved your query, please mark it as the Accepted Solution to help others. Additionally, I would appreciate a 'Kudos' if you found my response helpful.

Thank you!