Now that you have learned about the three different ways to connect to your data, you're left to wonder which option is best for you. It's fair to say that the choice you make will really depend on the requirements of each individual project you have. To summarize, some of the considerations that were mentioned in this chapter are listed in the following table:
Consideration |
Import Data
|
DirectQuery
|
Live Connection
|
Best performance |
X |
X |
|
Best design experience |
X |
||
Best for keeping data up-to-date |
X |
X |
|
Data sources availability |
X |
||
Most scalable |
X |
X |
Some of these items to consider may be more important than others to you. So, to make this more personal, try using t