Forum Discussion
Default Dataset Refresh
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.
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.
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.