Sage Alerts & Workflow refresh a power query?

Wondering if it’s possible to have Sage Alerts & Workflow refresh a power query right before it sends it as a file?  Maybe with & Sage Alerts script? Need to send it as a power query file vs. a crystal report since can’t duplicate data in crystal reports.  Ex. Customer orders 10 cases of oil, there’s only 1 line in Sage but I need the data repeated 10 times (1 label per case).