A limitation to Import is that your data is only as fresh as your latest refresh. Sometimes refreshes can fail and cause delays in getting updated data. On the other hand, while Direct Query will provide you with the most current data, this method can also mean slower performance and more limited DAX capabilities.