i have power query report which need to refresh every day and send the report via email. The problem is, i try to use Run Script in power automate to refresh the data but its still not updated. I read that power automate has limitation for this feature, but in a way if u have any suggestion or workaround for this problem, I would be so grateful. Thanks!
Workaround to refresh excel using power automate
I know Power Automate can refresh Power BI Datasets. Perhaps you could turn your query into a Power BI Dataset, and either refresh automatically in the service or via a flow.