Default Dataset Refresh

[smpa01]

Issue: I am trying to generate a power automate action based on data-driven alert triggered from a measure set up on the default dataset stemming from Datamart.

The following is the wokflow.

Even though the datamart is refreshing as desired (set up through power bi), the default dataset is not refreshing, as a result the alerts are not triggering and PA is not doing what I expect it to do.

To resolve this, i tried to set up scheduled refresh of the default dataset through PA which gives me Invalid dataset. This API can only be called on a Model-based dataset

I am looking for a solution that can trigger a power automate flow based on the datamart refresh (IDEAL - currently no trigger- such as when a datamert is refreshed) /  Data Driven Alert triggering (intended from the default dataset refresh; currently does not refresh through power bi nor can it be refreshed with PA as it generates Invalid dataset. This API can only be called on a Model-based dataset)

Thank you in advance.

Follwoing is the refresh time stamp.

[Anonymous]

Hi @smpa01 ,

Based on the description, try to check that default dataset is set to the appropriate storage mode.

What’s more, alerts work only on refreshed data.

You can also view the following documents to learn more information.

Solved: Scheduled refresh dataset in Power Bi from Power A... - Microsoft Fabric Community

Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Learn

Set data alerts in the Power BI service - Power BI | Microsoft Learn

Get started with datamarts (preview) - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01 · Accepted solution]

@Anonymous thanks for looking into it, comments in green.

Based on the description, try to check that default dataset is set to the appropriate storage mode. - If you are somehow suggesting that, the datamart table storage mode needs to be changed to IMPORT in order to achieve ewhat I need; Datamart tables have default storage mode as DQ and it can't be changed to Import; feel free to correct me if I am wrong. But my research suggests that DQ is the only option.

The ISSUE

The main issue in this, how can I create a alert dependent on a default dataset from datmart that auto-refreshes on a regular interval.

I created a thin report (and measures and alerts based on that) based on the default dataset only to realize later that alert would never work cause default dataset never refreshes. The prereq of an alert is that it only works on a refreshd dataset and default dataset never refreshes.

The FIX

Therefore, instead of creating a thin report I created a report with DQ by running a SQL query on the db table of the sql server that datamart produces and I have made dependent measures and alerts based onthat. Since it is a a DQ, I don't need to set up any explicit refresh schedule as it can run at a fixed interval of my choice=-> create measures=>generate alert=>feeds dowsntream PA.

TLDR: For a datamart depenedent data-driven alert to trigger, don't make a thin report from the default dataset, rather create a report with DQ by running a SQL query on the SQL server db it comes with.