Upload Excel workbooks to Workspaces programmatically

[edwardrmiles]

Is it possible to upload* Excel workbooks to Workspaces programmatically? I've has a look at the REST API documentation but haven't found anything

Basically I'm trying to overcome the problem of not being able to refresh an Excel workbook that uses Power BI as a data source when it has been uploaded to a Workspace (as described here in Chris Webb's blog). My thinking is I could refresh locally and publish to Power BI on a schedule

*Upload, not import i.e. the Excel online in Power BI type experience

[v-micsh-msft]

Where is the Excel File stored? Does the Excel file need to be replaced with different versions?

Power BI could sync the Excel file directly when the file is stored under OneDrive or OneDrive for Business (Package refresh).

But if here you would like to update the Excel file, it is not available through Power BI, or through Power BI Embeded API.

You may take a look at Microsoft Flow, to configure schedule update for the Excel files stored in OneDrive.

Regards,

Michael

[edwardrmiles]

@v-micsh-msft the Excel file will most likely be stored as a local file but could be OneDrive, however it's that automated publish which is important. This is beacuse you cannot refresh an Excel Workbook that has been uploaded to a Workspace.  

Automating refresh oustide of Power BI is quite straightforwdard (e.g. using Powershell or VBA) so if I can automate the publish to a Workspace part I can overcome the problem