Forum Discussion

mbrierley's avatar
mbrierley
Advocate II
2 years ago
Solved

Datamart not refreshing

I'm getting the following error when I try to refesh my DataMart. "Error: undefinedErrorMessage=The current operation was canceled because one or more operations failed..HttpStatusCode=0."   Does ...
Need Help
  • mbrierley's avatar
    mbrierley
    2 years ago

    We found the problem. One of the data sources had a field with a marked key on. We changed the format of this field from text to number, and this seems to have caused the problem.

     

    It would have been really helpful if the error messages had told us this, as when we went to refresh the data source, there was no indication that this was what was causing the whole Datamart not to run. 

     

    I added the suggestion as you recommended and have fed this back 

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".

 

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