How to create a Task using a PowerBI Supporting Report using DAX queries (with example)?

How to create a Task using a PowerBI Supporting Report using DAX queries (with example)?

FIRST CREATED ON 23 October 2025  I  AUTHOR Emma Camacho

Following the example How to create a Word report using PowerBI as a data source in Mail & Deploy using DAX queries (with example)? we are ready to send the Reports to the Store Managers. The following screenshot is the Supporting Report created to manage the Store Manager recipients. The Flag field indicates who wants to receive an email and who doesnt.



the Task looks like this:


Let's expand the actions:

CYCLE OVER VALUES




EvaluateDaxOrDmvDatasourceExpression( "M&D Demo_Supporting Report", "EVALUATE 'Store Managers' ", 1 )
For more information, see EvaluateDaxOrDmvDatasourceExpression.

You will gain access to the whole row of the table using the CycleValue and expression Value, for example,  [CycleValue].[Store].Value("Email") to get the current Email.

OUTPUT DEBUG INFORMATION


"Cycle over values: " & [CycleValue].[Store].Value.ToCsv()

This action is just for debugging purpose. The expression ToCsv() will display the whole row separating the fields value with a comma. The execution log will display something like this:

GROUP

[CycleValue].[Store].Value("Flag")=1

Only send emails to Store Managers that want do receive emails.

CREATE REPORT DOCUMENT


The Report is designed to receive as a Parameter the name of the Store. The Report itself will filter (using the CALCULATE clause) the expressions and tables to the Parameter.

Send E-Mail






The Report's filename will be the name of the Store and it will be sent to the corresponding Email.
The Cycle will go through all the Stores in the Supporting Report and all the Store Managers with Flag = 1 will get a Report.

Info
Looking for Additional Guidance?

If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.


    • Related Articles

    • How to create a Task using a PowerBI Supporting Report using SQL queries (with example)?

      FIRST CREATED ON 13 October 2025 I AUTHOR Emma Camacho Following the example How to create a Word report using PowerBI as a data source in Mail & Deploy (with example)? we are ready to send the Reports to the Store Managers. The following screenshot ...

    • How to create password protected PDFs?

      FIRST CREATED ON 19 May 2023 I AUTHOR Emma Camacho To create password-protected PDFs using Mail & Deploy, please follow these steps: (1) In the Create Report Document Action -> FILE TYPE -> Adobe PDF Document (2) Go to SETTINGS -> Has User Password ...

    • How to create password protected Excel Reports?

      FIRST CREATED ON 16 Jul 2025 I AUTHOR Emma Camacho To achieve the same functionality as the Excel's feature File > Info > Protect Workbook > Encrypt with Password please follow these steps: 1) Create the Excel Report 2) Call the expression ...

    • How to manually send notifications when a task fails?

      FIRST CREATED ON 16 December 2024 I AUTHOR Emma Camacho Sending E-Mail Notifications in Mail & Deploy when a task fails ensures that you’re promptly informed of any issues. Although you can use the automatic E-Mail Notifications in Mail & Deploy (for ...

    • How to add the user name to a Task when requested by M&D Hub

      FIRST CREATED ON 19 Aug 2025 I AUTHOR Emma Camacho Add a parameter with the following Hub Input Field options Type: Drop-Down Field Source: User Name The Task Parameter can be used in the Tasks' actions, for example Looking for Additional Guidance? ...