Datamart Refresh

[smpa01]

Is there any way to progrmatically refresh datamart through  any of  - powershell/REST API/ Power automate

[lbendlin]

you get that for free when you refresh the upstream dataflows.

[smpa01]

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

[lbendlin]

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]

@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]

did you raise a ticket with them?

[smpa01]

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