Power Automate - Automatically fetch data from Power BI in to Excel and Send the copy of the Excel file via Email
Power Automate - Automatically fetch data from Power BI in to Excel and Send the copy of the Excel file via Email Step-1 Step-2 Step-3 Using Command text we can make changes in the data we fetch from the Power BI. Like add fields/columns, filter data, rename columns. It is a DAX formula. Step-4 Step-5 Step-6 Step-7 Posting message on Teams. We can post message to a Teams Group also by selecting Group chat from Post in and select the Teams Group from the Group chat dropdown that will appear after making selection. Step-8 Location: We need to select the Group on SharePoint in which our file is located. Document Library: We need to select the Documents option from the dropdown. File: Select the file on which you want to run the script. Script: Select the script to perform the desired action. Step-9 Step-10 Step-11 Using Filter Query we can decide which file properties we want to get. We are performing this step to attach excel as an attach...