Datamart operation canceled

OK, thanks for the quick reply.  

Hi team,

I am facing the same issue. I dont think there is any network issue. 

This has happened 2 times now. Suggested steps

a) Import Data from multiple dataflows into a data mart (The data mart should be a existing datamart, few tables in the datamart should be more than 1Mn rows, not new)

b) Import a new large table, more than 1 million records. Wait for 10mins, if the import of table is still going on with the message "Wrapping things up"....hit "Go back to Workspace"....

c) Get into same datamart again, it will ask for continue from last where we left.

d) Hit cancel

e) It will take to edit screen

f) Hit Save button.

g) you should encounter the above issue. 

Hi debiagui ,

I was facing the same issue earlier and was able to find the cause.

In one of my table, there was a column with the data type of Any. Changing the data type fixed the issue for me.

Steps to troubleshoot this:

1. Exported the power query template from datamarts using the 'Export template' button.

2. Created a new dataflow Gen 2.

3. Imported the PQT file into dataflow Gen2 and tried to load it.

4. It failed to refresh but produced a detailed report of load status of each table.

5. Figured out that one of the tables had a "failure to convert to number error".

6. The detailed error report needs to be available in Datamarts as well.

also have this exact same issue. How long has datamarts been in "Preview" for?