Forum Discussion

rubymaya's avatar
rubymaya
Helper III
3 years ago

Datamart Limitation?

Hi,

I'm trying to migrate my dataset to DATAMART, so that everything can be online and and I dont need to download to troubleshoot model. But then i found many issues/limitation :

 

1. When it stucks because of error 400 or 500 (i have raised in other thread), it doesnt specify which one is the problematic query
2. I can't migrate my CALCULATED COLUMN because all the tables are DIRECT QUERY, the change mode is greyed out
3. Many-to-Many is not allowed.

So now, im stuck at migrating my project. Could anybody guide on the workaround in case you have found similar issue.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  rubymaya ,

     

    Based on your three consulting questions, here are some of my views and opinions

    1. If your datamart is stuck in the last step of saving due to error 400 or 500, you can first consider going to each query of datamart for a preview refresh to make sure there is no problem with any query refresh, if there is then you can narrow down the problem, if not then you can consider that it is due to other reasons Because datamart is currently a preview function, there is a certain degree of imperfect development or issues exist, in this case you can expand the error detail and copy it to a new case for our technical support queries and analysis.

    2. As far as I know, the underlying logic of datamart is indeed connected to a newly generated dataset through DQ mode, and datamart and this dataset is a one-to-one relationship that does not allow the generation of multiple, so the creation of the report is also DQ data connection mode, but in fact, when the data is refreshed it still maintains the import mode of data refresh, for this The problem is also mentioned in the documentation.

    Get started with datamarts (preview) - Power BI | Microsoft Learn

    3. According to my queries and searches in the official documentation, it seems that many-to-many relationships can be supported in some cases, so do some research and testing by referring to this official document at your convenience.

    Analyzing datamarts (preview) - Power BI | Microsoft Learn

     

    Best Regards,

    Liu Yang

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

  • rubymaya's avatar
    rubymaya
    Helper III
    3 years ago

    Thanks for the reply Anonymous 

    1. Yeah i made sure i click every single query and refresh them without error one by one before clicking Save, and got 400 or 500 error. 

    2. So do you have any workaround for the calculated columns since the default is DQ.

    3. About many-to-many, it doesnt have the option for that, but actually, it just allows it because no relationship error when i run it. Havent check on the data behavior though.