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
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.