Forum Discussion

debiagui's avatar
debiagui
Resolver I
3 years ago
Solved

Datamart operation canceled

Hi I'm creating a new datamart using some dataflows as datasource, but I'm getting this error OperationCanceled ErrorMessageThe current operation was canceled because one or more operations faile...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi debiagui ,

     

    Can't reproduce the scenario, please consider to raise a support ticket.

     

    Best Regards,

    Jay

kashifkhan1987's avatar
kashifkhan1987
New Member
2 years ago

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.

Kieran_Ultra_23's avatar
Kieran_Ultra_23
Frequent Visitor
2 years ago

Hi kashifkhan1987 , 

 

This troubleshootings steps do not work if you are on a PPU license. I tried this using a fabric free trail and i encountered an error becasue i am on a PPU license.