cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Re: Refresh of Excel workbooks in App Workspace

@augustindelaf I'm not sure this will solve the problem. I'm not talking about using Excel as a data source. I'm talking about refreshing Excel workbooks that use a Power BI model as their data source - from within the Power BI service (i.e. the workbooks area of a workspace)

Re: Refresh of Excel workbooks in App Workspace

@edwardrmiles, we currently have this feature disabled in our tenant. However, I have the old workbook that was published before the feature was disabled. You should see the following button to schedule a refresh from the Excel Workbook.

ExcelScheduleRefresh.png

 

 

 

 

 

 

 

 

 

 

 

 

You should from here be able to setup the on-premise gateway refresh. Also, here is some more information regarding the refresh: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode#limitations-and-consideratio...

 

 

Re: Refresh of Excel workbooks in App Workspace

@richardlhughes unfortunately that isn't working when the Power BI model is the data source for the Excel workbook.  I see this message...

 

Capture.PNG

 

Re: Refresh of Excel workbooks in App Workspace

This idea is very close to the solution I'm looking for:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11040396-add-ability-for-excel-wo...

 

It's been planned, since March 2016...