dcm's avatar
dcm
Frequent Visitor
4 years ago
Status:
Investigating

Unable to access Datamart

Hello, 

I have added some changes (new table) to my datamart on Friday and left it to run until it completed. Once I came back the I had the triangle next to my Datamart and this message:

 

 

Did anyone face something similar?
Considering 3 days have passed it does not seem like something I should just wait out... 

 

4 Comments

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    Status changed:
    New
    to
    Investigating

    Hi dcm,

     

    You may consider deleting this Datamarts and recreate one if you haven’t created reports based on it.

     

    Best Regards,

    Community Support Team _ Caiyun

  • dcm's avatar
    dcm
    Frequent Visitor

    I've already built a report on it, and I would like to keep it if possible. 

    Is there at least a way to get the M code from the queries that I've created?

     

  • ElaineK's avatar
    ElaineK
    Frequent Visitor

    Hi,

     

    I'm having the same issue and have created a few reports and dozens of calculated measures so not really an option to recreate the datamart again at this stage - I have already rebuilt once so this is my second effort. Understand that this is in preview, but any alternative advice other than recreating and starting again would be super helpful!

     

    Thanks

  • dcm's avatar
    dcm
    Frequent Visitor

    ElaineK 

    I have raised a ticket with MS Support in order to revert the change to the previous working version of the Datamart, but I still did not get a solid response.

    Unfortunately for me the route was to rebuild the Datamart in Dataflows and wait for it to be stable before using it for anything.