Hi @PADUser123,
Power Query can create POST requests to a web service, thereby passing values in the body of the call to the web service. This allows to export the data from Power BI. With Flow, it is very easy to setup a web service: Just create a Flow whose trigger is a “When a HTTP request is received” (no further inputs in that step) and add a “Compose”-action with the Body-element in it. Then save the Flow and copy the generated URL:
Or you could search for the Export to File for Power BI Reports action and go to Power BI service, and open the report we need to export. On the page you need exported you need to copy the last part of the URL, paste it to the "Pages pageName - 1" section.
Next, search for "Send an email v2", click within "Attachment Content", select "File Content" from among the dynamic content to attach your exported Power BI report.
