Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago

Datamart Refresh

Is there any way to progrmatically refresh datamart through  any of  - powershell/REST API/ Power automate  
Need Help
smpa01's avatar
smpa01
Community Champion
2 years ago

lbendlin  can you please elaborate, I did not understand what you meant.

lbendlin's avatar
lbendlin
Super User
2 years ago

datamarts are nothing more than dataflows with a Azure SQL database bolted on in front. Whenever parts of your dataflows refresh that then refreshes the datamart.

 

Disclaimer:  I am aware of the current bug with the datamart scheduling dialog

Opinion:  datamarts have been in preview for too long. Doesn't sound as if they will ever be made GA

  • smpa01's avatar
    smpa01
    Community Champion
    2 years ago

    lbendlin if you are suggesting that

    whatever parts of my dataflow refresh

    that

    automatically refresh the corresponding datamart (without requiring a refresh schedule being explicitly set up) that ingested the same dataflow

     

    is not correct.

     

    I have tested out your suggestion for last couple of weeks and I can confirm that it does not refresh automatically without an explicit refresh schedule being set up.

     

    I hope MS looks into it.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      did you raise a ticket with them?

      • smpa01's avatar
        smpa01
        Community Champion
        2 years ago

        lbendlin I have tested out your suggestion on 3 different workspaces with the hope that you are right. But after a through test, it sadly did not prove to be correct. If you have any literature indicating that, pleae let me know, i will take it up with MS by referencing that.