Forum Discussion
Datamart not refreshing
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
mbrierley Probably some kind of transient issue in the Service. Seems to be happening recently. You'll have to contact support and provide them with the correlation ids to get to the bottom of what is going on.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
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