Forum Discussion
ucmaoTWG
Helper I
Helper IUnable to refresh an Excel Workbook linked to a dataflow
Hello, I have an excel workbook that is linked to a dataflow in the same workbook. My understanding was that I could set up a refresh for the excel book so that whenever the data flow is refreshed, ...
ucmaoTWG I hit the same problem as you. Cannot believe how challenging this is. In my case I have a set of Dataverse tables backing a Model Driven App. I want to be able to share a view of the data with users in my company who will never have Power BI licences. I figured a Dataflow was the way to go, but discovered Excel Online doesn't support refreshing of Dataflows (yet). I wouldn't mind if I could find an alternate way to get the data out of Dataverse that didn't involve building a Power Automate flow. It's not that I can't do this, it just doesn't seem like the right approach. Open to any other suggestions!