Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Datamart shows fake successfully refresh

Hi experts,

 

I need your help!

I have a Master_Datamart which appends data from 2 other datamarts (say datamart1, datamart2). Each of the datamarts has a field called MaxValue (same name in both the datamarts)

 

  1. I made  changes in transformations (PowerQuery) to MaxValue of datamart2 and saved (reloaded).
  2. I created a test report on datamart2, and I can see the result of the change made to MaxValue in the datamart2.
  3. I reloaded Master_Datamart (open from transformation, saved) data, but the changes made in datamart2 are not showing in Master_Datamart.
  4. I tried to remove datamart2 in the Master_Datamart append step, reloaded Master_Datamart loaded data, re-added again, I still don’t see the changes I made on MaxValue datamart2 when I create a test report on the Master_Datamart, but the changes are visible on the datamart2.

 

I don’t see a refresh error in Master_Datamart. When I check the refresh history, I see a complete successful refresh status with the correct data/time of the refresh. But I know that a correct refresh did not happen. I don't see the changes.

 

Does anyone know what is wrong and how to fix it?

 

Thanks in advance for your help.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    According to your description, I created 3 datamarts:

    Masterdatamart uses the tables in datamart1 and datamart2 and then does an append:

    datamart1:

    datamart2:

     

    Masterdatamart:

    When I change the value in datamart2, masterdatamart is not updated automatically:

    When I refresh my browser/refresh datamart I find that masterdatamart does not update automatically:

    We can solve this problem by doing the following:

     

     

    Best Regards

    Jianpeng Li

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

     

     

     

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks so much for your response. Unfortunally , it does not work for me.