Which should I choose?
Now that you have learned about the three different ways to connect to your data, you are left wondering 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 |
Yes |
No |
Yes |
Best design experience |
Yes |
No ... |