2) You have to load somehow your data into the data model. That could be Power Query and/or PowerPivot connectors. After that updating the data is just refreshing of the connections and Pivot Tables.
Forum Discussion
Data Model Limitations
I have two questions about data models Would the excel data model (Office 365 64 bit environment) be able to handle a dataset with 11.5 million rows and 150 columns? (Note: none of these columns...
1) From formal point of view you may consider data model as unlimited. More exactly, there are limits, but they are as big as 1,999,999,997 rows, 2,147,483,647 columns and about same number of tables. Actually you are limited by your memory and performance. There are techniques to optimize memory usage and performance, but that is not straightforward.