Dataflow - Something went wrong message after validation

[blaster]

Can you please help me with my dataflow issue. I have a dataflow that has some sources (on prem SQL, SharePoint) and now I need to enable to load one of the table. When I click Enable to Load, then click the save and close button I can see that validation goes OK but then I get the message about " Something went wrong".

Details of the error:

Activity ID: 760df598-260e-47c0-afc8-c71e1b68dec6
Request ID: 1ef3280e-af87-ff7a-ac8c-1f709a3555a7
Correlation ID: 4777d3d1-0de1-ad0f-b8a6-20f1cc187458
Status code: 500
Time: Fri Aug 05 2022 12:02:48 GMT+0300 (Moscow Standard Time)
Service version: 13.0.18756.45
Client version: 2207.4.12439-train
Cluster URI: https://wabi-us-east2-redirect.analysis.windows.net/

[ibarrau]

Hi blaster. Sadly dataflows are not very expresive. That's the way the tool has to tell you that one of the tables has an error that won't allow to validate and refresh. If it was working until you enable that table, then you know it's that table. Sometimes we can't see the error in the top 100 preview rows. You need to deep dive on your transformations. The most frequent error is related with change of data types.

Sorry I can't help more but you will need to deep dive on that table.

Regards