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.
Jul 10 2019 11:06 AM - edited Jul 10 2019 11:10 AM
I have two questions about data models
Jul 10 2019 01:21 PM
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.
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.