XCT's avatar
XCT
Icon for Resolver I rankResolver I
1 month ago
Status:
New

Alerting on report KPIs using Activator in DirectQuery mode

Hi,

 

It's wonderfull to use Activator to set alerts on PBI report KPIs (in card for exemple) but it only works by refreshing your dataset.

In DirectQuery, we can see immediatly the change on KPI value inside our report. It doesn't work exactly the same with Activator.

By testing it, Activator needs semantic model refresh to ingest the value in the time database, and no matter if you're using specific DAX formulas in your measure such as NOW()... If not (with DQ), it ingests the same value of the last refresh...In this scenario alerting is no longer releviant.

Idea: make the ingestion with DirectQuery without any model refresh.

No CommentsBe the first to comment

Recent ideas