I built a flow that runs a query against a dataset and exports the result to a csv file on sharepoint. I scheduled it to run daily. When I test the flow, it works fine. But the next day, the flow runs but returns an empty table. When I hit resubmit, it works fine again. I don't understand what could be the problem here? Any help would be much appreciated.
// DAX Query
DEFINE
VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('fCallQueueAnalytics'[Call Start Time Local])),
AND(
'fCallQueueAnalytics'[Call Start Time Local] >= DATE(@{variables('varYesterday')}),
'fCallQueueAnalytics'[Call Start Time Local] < DATE(@{variables('varToday')})
)
)
VAR __DS0Core =
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP(
'fCallQueueAnalytics'[Call Start Time Local],
'fCallQueueAnalytics'[CQ Name],
'fCallQueueAnalytics'[Call Queue Call Result],
'fCallQueueAnalytics'[Call Queue Agent Count],
'fCallQueueAnalytics'[Call Queue Agent Opt In Count],
'fCallQueueAnalytics'[Call Queue Call Result Legend],
'fCallQueueAnalytics'[Call Queue Target Type Legend],
'fCallQueueAnalytics'[PSTN Connectivity Type],
'fCallQueueAnalytics'[ConferenceID],
'fCallQueueAnalytics'[CQHour]
), "IsGrandTotalRowTotal"
),
__DS0FilterTable,
"Avg_of_Average_CQ_Duration___zero_instead_of_blank", 'fCallQueueFinalStateAction'[Avg of Average CQ Duration - zero instead of blank],
"AverageAverage_Call_Queue_Duration__Sec_", CALCULATE(AVERAGE('fCallQueueFinalStateAction'[Average Call Queue Duration (Sec)]))
)
VAR __DS0PrimaryWindowed =
TOPN(
2000,
__DS0Core,
[IsGrandTotalRowTotal],
0,
'fCallQueueAnalytics'[Call Start Time Local],
1,
'fCallQueueAnalytics'[CQ Name],
1,
'fCallQueueAnalytics'[Call Queue Call Result],
1,
'fCallQueueAnalytics'[Call Queue Agent Count],
1,
'fCallQueueAnalytics'[Call Queue Agent Opt In Count],
1,
'fCallQueueAnalytics'[Call Queue Call Result Legend],
1,
'fCallQueueAnalytics'[Call Queue Target Type Legend],
1,
'fCallQueueAnalytics'[PSTN Connectivity Type],
1,
'fCallQueueAnalytics'[ConferenceID],
1,
'fCallQueueAnalytics'[CQHour],
1
)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
[IsGrandTotalRowTotal] DESC,
'fCallQueueAnalytics'[Call Start Time Local],
'fCallQueueAnalytics'[CQ Name],
'fCallQueueAnalytics'[Call Queue Call Result],
'fCallQueueAnalytics'[Call Queue Agent Count],
'fCallQueueAnalytics'[Call Queue Agent Opt In Count],
'fCallQueueAnalytics'[Call Queue Call Result Legend],
'fCallQueueAnalytics'[Call Queue Target Type Legend],
'fCallQueueAnalytics'[PSTN Connectivity Type],
'fCallQueueAnalytics'[ConferenceID],
'fCallQueueAnalytics'[CQHour]
Share
Report
All responses (
Answers (
522
