2) I am the administrator myself, and I didnt' disable datamart
3) Yes, I was using this datamart before and I was not able top open it
It happen quit often from time to time, that at some it just becomes unavailable, and seems that there is no other option but just wait until it becomes available again. Is there any way to manually restart server/datamart?
I was getting the same error as you are that says "We couldn't retry your suspended datamart". After a few hours I was able to open the datamart again. Currently it seems the datamart feature is in preview release and is very buggy. Hopefully Microsoft BI team @Anonymous can fix these issues with datamarts.
For the time being, I decided to take a different approach. I decided to split all the ETL steps into 3 different steps using 3 dataflows... initial staging dataflow, followed by phase 1 of the transformation, and finally phase 2 of the transformation. After the 3 dataflows, I then have a datamart that just uses the already transformed data from the last dataflow and loads it into the database within the datamart. Although, not an ideal solution, I was able to bypass the datamart errors for the time being. Hope a similar approach helps with your situation. Best of luck!
thanks for reply. Yes, your approach seems logical. I probably will do the same. But at least I need to open my datamart, to copy all exisiting queries from datamart to dataflow.
And 24 hrs later, datamart still is "not finalized in a failed state".
Thank you for the information you have provided: This has been confirmed as a bug from Microsoft support team, which is planned to be resolved within the next 3 weeks or so.
