Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Incremental refresh on Datamart tables

Hello,

I have been trying to configure incremental refresh on multiple tables in a datamart.

However, after configuring incremental refresh on table1, the Loading Data window appears and I have to wait for data to finish loading. Then I do the same on table2 and I have to wait again.... 

Is there a way to configure refresh on all tables and then apply all changes and load data once?

Note: in this Data Mart, a Power Query script connects to a sharepoint site and then loads data from Excel files.

Thanks.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Sorry, so far, to my knowledge, this may not be achieveable.

     

    Best regards,
    Community Support Team_Binbin Yu
    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
      2 years ago

      Thank you  Anonymous for your response.

      I take note of that, while hoping that this constraint will be waived in the near future.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ,

        You could submit idea in this site Home (microsoft.com)), if a idea is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

         

        Best regards,
        Community Support Team_Binbin Yu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.