Power BI Direct Query (Live connection)

Hii jishnubhattacha 

If real-time data is truly required, use DirectQuery (or Live Connection to a semantic model), but first validate that “real-time” means seconds/minutes not hourly. Power BI Import mode is recommended for performance; if near real-time is acceptable, use Import with Incremental Refresh + Hybrid Tables instead. For strict real-time, keep DirectQuery but optimize the source: use a proper star schema (avoid complex parent-child joins in views), reduce columns, ensure indexed keys on fact tables, push transformations to the database, avoid bi-directional relationships, and use aggregations where possible. The 8-minute load indicates source/query inefficiency, not a Power BI limitation. So guideline: use Import for performance; use DirectQuery only when real-time is mandatory and the database is well-tuned.

Hi jishnubhattacha ,

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  rohit1991 and cengizhanarslan  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team  

Dear  @rohit1991 and @cengizhanarslan 

Thank you for your suggestions we are working and for any difficulties we will reach you.

Regards

Jishnu B