Hi,
We have requirement for our paginated reports power automate flow --> If there is no Data in the report we are not supposed to send out the empty attachment in the email. Is there any function we can use for this requirement?
We have that option in SAP Business objects, but I cant seems to find the option in PowerBI/Power Automate.
Post a screenshot of your flow with identifying information blacked out for a recommendation on how to check in the flow.
for this query below, i just need to add a where clause sender_id = 77110, how do we add where clause n DAX ?
// DAX Query
DEFINE
VAR __DS0Core =
SUMMARIZE(
'Query1',
'Query1'[dest_id],
'Query1'[edi_file],
'Query1'[file_name],
'Query1'[insert_dt],
'Query1'[notes],
'Query1'[receiver_id],
'Query1'[ref_id],
'Query1'[sender_id],
'Query1'[status_ind],
'Query1'[sum],
'Query1'[tracking_id],
'Query1'[trans_type],
'Query1'[task_count]
)
VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
'Query1'[dest_id],
1,
'Query1'[edi_file],
1,
'Query1'[file_name],
1,
'Query1'[insert_dt],
1,
'Query1'[notes],
1,
'Query1'[receiver_id],
1,
'Query1'[ref_id],
1,
'Query1'[sender_id],
1,
'Query1'[status_ind],
1,
'Query1'[sum],
1,
'Query1'[tracking_id],
1,
'Query1'[trans_type],
1,
'Query1'[task_count],
1
)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
'Query1'[dest_id],
'Query1'[edi_file],
'Query1'[file_name],
'Query1'[insert_dt],
'Query1'[notes],
'Query1'[receiver_id],
'Query1'[ref_id],
'Query1'[sender_id],
'Query1'[status_ind],
'Query1'[sum],
'Query1'[tracking_id],
'Query1'[trans_type],
'Query1'[task_count]
we basically have Prompts in the report and those prompts kind of work after the report has fetched all the data.
So we open the paginated report on Workspace, and it brings al the data, and we select the prompts( parameters) and then the related data shows up. Now in the option of showing Null in the flow, we do have that option, but then it only shows the DAX query without the parameter, so basically it will look for the NULL data for the entire data and not for the ones specified in the report.
So question, we have a DAX query in the Flows, is it possible how to add the parameter selected value in the DAX query ? I have not worked with DAX query before, so wanted to understand how to add the where clause of that paramter in the dax itself
how do we check that ? is it possible we can check that in Power Automate flow itself ?
Have you tried checking whether the content of the report is null or its length before emailing?
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2