Datamart is not refreshing

[mbrierley]

The DataMart has been working in the main, although automated refreshes have stopped a few days ago. Now I can't even refresh manually and am getting the following error. 

Error: undefinedErrorMessage=The current operation was canceled because one or more operations failed..HttpStatusCode=0.

This means all the work that we've done to establish this new process using PowerBI risks being compromised. If we can't fix this, then we may have to abandon it, which would not be great. 

[Anonymous]

Hi @mbrierley ,

Can't reproduce the issue at the moment, did you make any changes before it happened?

Verify that the credentials for the data sources used in the Datamart are up to date and have not expired or been changed.

And you may also check if there are any resource constraints, such as CPU, memory, or network limitations, that could be causing the refresh to fail.

Best regards.
Community Support Team_Caitlyn

[mbrierley]

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 casuing the whole Datamart not to run. 

[Anonymous]

Thank you for sharing, for other users with similar experiences you can check the comments below. This thread will now be closed.

Best regards.
Community Support Team_ Caitlyn