If a dialog window is displayed select the Save and run option to continue. Once you have updated the following configurations, select Apply to save your changes. This activity will now be invoked if the OnlineSalesActivity fails.įrom the Home tab, select Schedule.

Select OnlineSalesActivity and from the available path options, select and hold the 'X' (On fail) to create an arrow that will be dropped on the Mail on failure activity.

Select Functions and insert the following function by selecting the corresponding name from the following table. Select System variables and insert the following variables by selecting the corresponding name from the following table. In the Pipeline expression builder, paste the following expression code block: ' More e-mail configuration options such as From (Send as), Cc, Bcc, Sensitivity label and more are available from Advanced properties. Set the Update method to Append and then select Save settings. Select SalesLakehouse and confirm that the default New table is selected before selecting Next to continue. If necessary, set the authentication to Organizational account and then select Next.įrom the navigator, select the workspace used for this tutorial and expand to view all Lakehouse items. Select the FactOnlineSales query under the Data transformation query group and from the Home tab, select Add data destination and then select the Lakehouse option. In the bottom right corner of the Power Query Online editor, you can find the configured Data destination settings for your query where you can further customize or remove.īefore moving on to the next section of this tutorial, make sure to perform the same steps as you took earlier in this section to configure the Lakehouse as your data destination for each of the following queries.

Setting the update method to Replace deletes all existing data and replaces it with the new data on each subsequent refresh.

Power rename download