"We couldn't load your datamart"

[sldkfjasdlk]

Datamart is suddenly uneditable and unable to be refreshed.  All underlying dataflow tables are accessible and able to be used.  Existing reports on top of this datamart can still be accessed.  

The message when attempting to refresh: "Unable to open the datamart because it is not connected to its dataset. Wait a few seconds, and then try again."   Have tried periodically for over 8 hours.

Activity ID: 318df93b-b0f7-426a-876d-24a7ceb9d528
Request ID: 5ff5c016-ccfd-4b69-8cf0-e33af0f88dd5
Correlation ID: 38855fed-9a6b-cee7-1f47-7e4ad63816e8
Status code: 400
Time: Fri Feb 03 2023 16:48:03 GMT-0500 (Eastern Standard Time)
Service version: 13.0.19958.49
Client version: 2301.4.12022-train
Cluster URI: https://wabi-us-west2-redirect.analysis.windows.net/

[v-yetao1-msft]

Hi @sldkfjasdlk 

When did this condition start ? Are all your datamart not refreshable anymore ?

Best Regards,
Community Support Team _ Ailsa Tao

[sldkfjasdlk]

Hello,

The first failed refresh was on Friday morning (2/3).  I was still unable to access over the weekend and this morning. 

I have two datamarts and only one is affected.

Thank you

[heba__abdelshaf]

Me too have the samr issue last Thursday 9 feb 2023

Activity ID: 0604011e-9d13-4231-a2fb-6cfdd2027d2f
Request ID: d8a7e928-1277-4bf9-b6a5-7f6434cdca31
Correlation ID: 62bff530-9606-34ea-c9b9-10605a39ec78
Status code: 400
Time: Sat Feb 11 2023 11:08:01 GMT+0200 (Eastern European Standard Time)
Service version: 13.0.20006.56
Client version: 2301.5.12183-train
Cluster URI:

[diegor3T]

I have the same problem since today  3 March 2023. Is there any solution for this problem?

[cbilsoe]

We also have this issue, we simply cannot open our datamart anymore. We would like to avoid having to redo the whole datamart

[VanEnkhuizen]

Same issue here. The dataset of the datamart only holds 1 table, instead of the 40 other ones.

---

We couldn't load your datamart

The batch '8ef7318e-484c-47e0-95cd-11101386ece4@ef6d24e7-187a-443d-8216-c0268bf16759$2023-03-28T16:52:12.3957478Z@41e6fb1e-cced-4927-b221-3138d37db5b2' was submitted on the datamart '8ef7318e-484c-47e0-95cd-11101386ece4' that is not in an available status.
Please try again later or contact support. If you contact support, please provide these details.
Hide details
Activity ID32a00f61-758f-4dc6-aa4e-27f1b3a77ed3
Request IDe0f38fd1-5d56-4300-af8b-1da2fc5b8098
Correlation ID5a64057f-01a5-92c1-7e7b-d1b3ad218d5b
Status code400
TimeTue Mar 28 2023 18:52:28 GMT+0200 (Central European Summer Time)
Service version13.0.20342.55
Client version2303.3.12949-train

Cluster URIhttps://wabi-west-europe-b-primary-redirect.analysis.windows.net/

----

My order of steps: add an extra table to data mart, let it finish import, after import fatal error.

There are many similar questions in the forums, but none provide a solution. 

This one is marked as solved, but is actually not solved:

https://community.powerbi.com/t5/Service/Datamart-error-Unable-to-open-the-datamart-Wait-a-few-secon...

[StevenVF]

This has happened to me twice in the last week:

Activity ID: 8b82cccb-38d2-456f-9dfa-c6890797ccec
Request ID: 8f5e1a51-f77f-4ab5-8c21-76ba1e22d33c
Correlation ID: 26b28bdf-a430-bf4b-62d0-4dc492d49059
Status code: 400
Time: Mon Apr 03 2023 10:02:28 GMT+1200 (New Zealand Standard Time)
Service version: 13.0.20392.66
Client version: 2303.4.13065-train
Cluster URI: https://wabi-australia-east-a-primary-redirect.analysis.windows.net/

I opened a support ticket for the first time and the only way to recover it was to rebuild it according to them, there was some process where by doing a trace we could get a Json File, But it require you to manually copy everything out of the file and ingest all the tables again........

All i did today was add a very simple table via get data and it's made my datamart unsualble as it's in this "Unavaliable state" again.....

I know this is a preview feature, but come on it's been in preview for over a year, it's a complete joke, either get it working and release it or withdraw it. I really want to use this as it's a great feature, but i've been burnt twice now, i'm only using this for one report and everytime something like this happens i have to watse a day getting it working again.....

[HALoud]

has there been any fixes to this, I have had this same error crop up with one of my datamarts, it will not open keep getting the "We couldn't load your datamart" Error