Forum Discussion
Refresh Excel Workbook published automatically on demand
Hello experts, We have a CSV file present on sharepoint. We have an excel file uploaded on Power BI Service which is connected to that CSV through get data approach. We want an automated approac...
You can do this in a roundabout way, using Power Automate if you go via a Power BI dataflow or dataset refresh, then Analyze in Excel. I'm not sure Power Query refreshes in Excel can be automated, last time I checked it wasn't working via OfficeScripts but I think they planned to add support for it.