Is it possible to refresh an Excel workbook - via the Power BI Service - that has been uploaded (not imported) to an app workspace? The data model for my Excel workbook is the Power BI data model and I'm connecting using the 'Analyse in Excel' option
If we can't refresh Excel workbooks that have been uploaded to an app workspace then what is this feature really for?
To replicate..
1) In a worksapce navigate to the datasets
2) Select 'analyse in Excel' option for a dataset
2) Excel will open and using the pivot table tools make a pivot table from the datset data
3) Test the report refreshes (Data > Refresh ALL) and then save the workbook to file system
3) From the workspace select Get Data > Local file then select the workbook form your filesystem
4) Select the Upload to Power BI option, not the import option (that won't work either but that is by design)
5) Open the workbook from the workbook section of the workspace and try and refresh
