I've been following this one over the years and I know there have been updates recently. Every day, I open an excel file, refresh a dataflow, save as csv and to a client.
I saw the thread about locating the file on azure, but I won't have that level of access with the size of my organization. I have premium powerbi access & premium workspaces, but thats about it.
I've also seen other workarounds, but they end up being powerBI reports/PDFs instead of the raw data file we need. I saw one with a script that works in PowerBI desktop, but not in the cloud. I've tried searching for other workarounds, knowing that if I can get it into sharepoint as a csv or a list that I could get into an email. It seems like everything still involves a manual trigger, which kind of defeats the purpose.
A lot of threads are older as well, and I don't have the same button/features in the interface anymore to try. Am I at a dead end?
