topic Upload Excel workbooks to Workspaces programmatically in Developer

Upload Excel workbooks to Workspaces programmatically

edwardrmiles — Thu, 12 Apr 2018 15:04:33 GMT

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

Re: Upload Excel workbooks to Workspaces programmatically

v-micsh-msft — Fri, 13 Apr 2018 01:55:11 GMT

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

Re: Upload Excel workbooks to Workspaces programmatically

edwardrmiles — Fri, 13 Apr 2018 08:48:39 GMT

@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