Datamart compatability with PA

[smpa01]

Is default dataset refresh compatiable through PA's automated triggers?

@lbendlin

@mahoneypat2 

[lbendlin]

Not sure what you mean. Please elaborate.

[smpa01]

Can you trigger a refresh of datamart's default dataset upon a src file modification in share point? If you can, I will be very interested; cause I failed to achieve that.

[lbendlin]

datamart's default dataset 

Not sure if that is even a thing.  A datamart is a dataflow with an Azure SQL db bolted on in front to make you think you could access dataflows in Direct Query mode.

[smpa01]

Okay, then can you trigger the refresh of a datamart upon a SP file modification ? Btw it is a thing, in case u have not discovered it yet. Datamart is double edged- the tables are both accessible through SQL as well SSAS (hence default dataset).

[lbendlin]

The default Power BI dataset created from a datamart eliminates the need to connect to a separate dataset, set up refresh schedules, and manage multiple data elements. Instead, you can build your business logic in a datamart and its data will be immediately available in Power BI, 

Understand datamarts (preview) - Power BI | Microsoft Learn

[smpa01]

I think we are drifiting away from the main question,

can you trigger the refresh of a datamart with PA upon a SP file modification ?

[lbendlin · Accepted solution]

Nopes

Solved: Refreshing a PowerBI Datamart with Power Automate ... - Power Platform Community (microsoft....