Unable to access or open datamart

[MarKha]

I created a datamart, but it stopped working after a few days.

There is an error icont that reads: 

Datamart is unavailable

Unable to sync the datamart with the automatically generated dataset. Some reports may not be updated. To try to repair this, select Transform data and then select Save.

When i open the datamart to edit, i get this error:

Internal error

We failed while handling this action: [Datamart Model] Load datamart succeeded

All queries seem to have disappeared.

The auto generated dataset still exists, but it is not refreshed.

[wallace13]

Hi all,
I opened a ticket, and after talking with Microsoft I have some updates to share. 

I was told the fix for this issue was rolled out June 2nd, however in some organizations (such as mine) the issue has persisted and the Product Group is still investigating why this is happening.  I will share with you all any further updates as they happen.

[wallace13]

Update:
The product group has confirmed that the bug still exists, and the fix that was rolled out earlier in June has not corrected the issue.  They are still working on the problem, no ETA on resolution yet.

[LeonB]

I am experiencing the same problem. It has already happened to me with two DataMarts that have been built. The only solution I have found was to rebuild them, but this is no longer an option for a third attempt. So I have come to ask if you have found any solution to the issue. It seems that using data flows will be the best option to play it safe, which makes the premium license not as useful anymore.

[wallace13]

Have you heard any update from Microsoft when this issue will be resolved?  I am experiencing the same issue. 

Until Microsoft fixes this it really makes datamarts unusable, since even if we recreate our datamarts they may just crash again in the future.  I assume they released this product as preview to see if it is something users want... I think there is a good use case for it, but if it isn't stable nobody can actually use it.

[v-yueyunzh-msft · Accepted solution]

Hi , @MarKha 

Based on my research internally, this is a known issue for the Power Bi datamart feature and the engineers are trying to figure out the root cause and fix it asap, meanwhile, you can kindly follow this list of steps to get the M query information from the broken unavailable datamart and create a new one with the same M query to keep using the new one and check if it can be used normally after then:

Datamart schema consists of the following:

Dataflow definition
Dataset definition
Database definition

To get these, send a GET request to the following URI:

https://<[baseUrl]>/v1.0/myorg/groups/<[groupId]>/datamarts/<[datamartId]>?$select=etl,xmla,views

To get these values:

1.Open 'Network' tab in developer tools for browser (by pressiong F12 key).
2.Click on the unavailable datamart.
3.It will show an error warning with 'Try again' button. Click on the button.
4.Locate 'resumeSuspendedBatches' call. Get the values from the 'Request URL' field of 'Headers' tab.(You need to change the end of the URL string to“?$select=etl,xmla,views” at the end of this request URL as mentioned in the format of this GET request)
5.For getting the auth token, under the 'Headers' tab, scroll down 'Request Headers' section. Copy the value of 'authorization' field (right click -> 'Copy value')

Send request

GET request can be sent through any tool that supports REST API. Example below is for Postman (https://www.postman.com/downloads/)

1.Select GET
2.Enter URL (as formed above)
3.Under 'Authorization' tab, select 'Bearer Token' as type. Paste the value of the token in the field. NOTE that the token may have a keyword 'Bearer ' prepended to it. Remove this from the token.
4.Hit 'Send'
5.The response status should be 200 OK. The response data would be under 'Body' tab.

Then you can copy the response value in yellow in above picture, open the notepad++(If you don’t have, you can download it as it’s free to use):

To change the response format and generate the same queries within the original broken datamart, Press CTRL-h and the Replace dialog will open in notepad++. Select search mode "Extended" and replace \" with ", \\r\\n with \r\n and \\n with \n.

Then you are meant to get the correct query format like this:

Then you can create a new datamart and select the blank query as the datasource, you may need to add them one by one into the datamart to make it as the same as the original broken datamart, here's the step:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[李立文]

链接中baseurl是在哪里获取？

Where do I get the baseurl in the link?