6
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.
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
#1
WarrenBelz
146,700
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
Share
Report
All responses (
Answers (
