Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

How does Data Warehouse gets refreshed?

If i don't schedule refresh on the Data Warehouse in my workspace, does the Data Warehouse gets refreshed once the data flow connected to it has refreshed successfully? 

 

Here, you see the dataflow has already refreshed but the warehouse doesn't refresh. it still stays at 21 Oct.

 

 

 

 

If it helps, im following this video to build historical data for usage metrics report but it seems that my data warehouse isn't refreshing although my data flow is already refreshed : Build Historical Data for Usage Metrics Report - Microsoft Fabric Way

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    GilbertQ I apologize for the misrepresentation, the point I was trying to make was that a refresh needs to be configured for the semantic model.

     

    Best regards,
    Community Support Team_ Scott Chang

    • Anonymous's avatar
      Anonymous
      Not applicable

      hi Anonymous , thanks for responding. i see, so that means i can only refresh my data warehouse every 30 minutes because the fastest schedule refresh configuration is 30 minutes, correct?

  • Hi Anonymous 

     

    Make sure when you have set up the data flow connecting to the warehouse that you have set it to append and not replace. Maybe it is replacing all your data.

    • Anonymous's avatar
      Anonymous
      Not applicable

      hi thanks for replying. but i think that didn't help because im already using append. by the way, i have attached a picture in the original post for clarification

  • Hi Anonymous 

     

    So when you query the warehouse you do not see any new data?

    • Anonymous's avatar
      Anonymous
      Not applicable

      hi GilbertQ , yes, when i query the data warehouse, i dont see the latest data until i click refresh on the data warehouse then only i see it

  • Hi  Anonymous 

     

    Can you please show me a screenshot of where the data warehouse has got a refresh schedule?

     

    As far as I know once the data is loaded into the tables, it could up to a minute to appear, but that happens automatically?