[DataFormat.Error] impossible to identify

[billybazinga]

Hi all,

I have been stuck on this for weeks and am desperate for help.

My model imports data from a large number of csv files (stored in sharepoint) as well as HAN cloud through ODBC. THere are a number of merge and append step which worked fine for a number of weeks and have now suddenly stopped working.

I get the following error but am unable to identify which field and which file triggers this issue, which I assume is a date format not correctly formatted. Everything in powerquery looks fine until I hit apply.

Does anyone have any suggestion as to what I can do to troubleshoot the issue?

Thanks in advance,

BBK

[Idrissshatila]

Hello @billybazinga ,

What I would do is that i go to Transformation Tab (Power Query), and try clicking on each table and refreshing it to see if it refreshes normally. The one with the error will display for you and show you which step has the error and what's the error.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[billybazinga]

Hello,

Unfortunately I have tried this but can't see any error in any of the tables 😞

Can DAX Studio help in any way? Or is there a problem solving approach people have taken in this scenario?