How to refresh from Excel - PBI -excel

We have built a nice forecasting model with a lot of input sheets. We need to be able to see the result from all these inputs during the forecast process. Ideally we would build a Pivot table connecting to the datamodel, since we have a lot of formatting and measures the will enrich the input data.

Is it possible to refresh the pivot so that it automatically pull the data from excel to PBI and back to the Pivot?

We have a data gateway installed. 

Best,

Lars