The #DirectQuery data connectivity in Power BI
The #DirectQuery data connectivity mode in #powerbi, why should we consider it for specific development scenarios?
It's useful when we need to:
**Build reports with large datasets
** Use the current data with real-time analysis scenarios
**Have scalable data model with no Limitation for 1 GB
When using the #DirectQuery mode, we should first consider some techniques to optimize the data source and then add some best practices when applying transformation steps into the #PowerQuery .