Error when loading data in Datamart

same issue here! 

Same issue, in my case it has paralyzed all my dataflows that are stored in azure, and I get the bugs described in the photos

Same thing. In my case the culprit is the extended date table from EDNA which we have as a dataflow.

Simply can't ingest it into the datamart.

Tried recreating it as a new blank query in the datamart itself. Doesn't work either.

Anyone figured out a workaround?

Although could not reproduce this issue, have other problems when testing the datamart as far as my test.

When I connected to an excel file in a dataflow, it has a date column and a value column with 3 rows. After creating a datamart and connecting to this dataflow, it would not remind the error but no rows show in the table.

Will continue to investigate the issues about datamart, if you have more detail about this issue, like the data source for the dataflow, the workspace type etc. which would help better to collect related information, you can share here.

Best Regards,
Community Support Team _ Yingjie Li

Same issue for me too.

Hope this gets sorted too as I cannot use the feature currently as we rely heavily on Dataflows in our Business.

Hi,

I managed to load in my data this morning, so issue seems to be resolved.

Best wishes,

Stephan

StephanB12  i cannot confirm. Just tried again to load some dataflow and i did not succeed! 

Hi onkelphill,

Please note my issue was related to loading up data in the new feature data mart, not a dataflow.

Not sure if this makes a difference?

Best wishes,

Stephan

StephanB12 thanks.

Just to add some detail, this is the error message. The dataflow holds just 1 table. There is 1 column of data type date, correctly formatted. 

I have the exact same issue and same error message.

In my dataflow the datetime columns are being created via the datetime function of power M. So it should really be valid datetime. I also tried to add a regional scheme to the column in the data flow, but the 500 error persists.