Forum Discussion
what model framework should I choose - Import or Direct Query ?
You seem to be very far away from a scenario that would require Direct Query mode. Continue with Import.
ashmitp869, Thanks for actively participating in MS Fabric community support.
You can continue using Import Mode with scheduled refreshes for now. If your dataset grows significantly in the future, consider enabling Incremental Refresh or switching to a Hybrid Model.
When to Use DirectQuery:
For real-time reporting directly from the API.
Your API can handle frequent queries without hitting rate limits.
The data volume is too large to import efficiently.
You don’t need complex transformations in Power Query.
data source is too dynamic to rely on periodic refreshes.
Thanks,
Prashanth Are
MS Fabric community support.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"