I've seen others in the community report this, but the Power BI Refresh a dataset action in Power Automate doesn't work with data marts! In the example below, I picked the dataset created by a data mart and get the following:
This is a real pain as data marts are wonderful, but if I can't automate their refreshes, they quickly become less appealing to me.
Please fix this so we can refresh data marts.
Currently Power Automate does not support refreshing datamart . You can mention your idea to the Ideas forum . If a feedback 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.
Community Support Team _ Ailsa Tao