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.
3 Comments
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
mbrierleyAdvocate II
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.
