Forum Discussion
Loads and security concerns on "DirectQuery Connection"
HiradKarimi,
Firstly, with DirectQuery connections, Power BI directly connect to the data source without importing data into data model of Power BI, and queries are executed at server(data source) side rather than Power BI side. When you have multiple queries and multiple/complex transformations, it will affect your server's performance.
Secondly, when you have reference queries in Power BI, consider to use Table.Buffer() function to reduce the number that Power BI send request to data source. And use List.Buffer() function to imporve calculation performance.
To better use the DirecQuery mode, please review the tips in the article below.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#guidance-for-using-directquery-successfully
Regards,
Lydia
HiradKarimi,
Firstly, with DirectQuery connections, Power BI directly connect to the data source without importing data into data model of Power BI, and queries are executed at server(data source) side rather than Power BI side. When you have multiple queries and multiple/complex transformations, it will affect your server's performance.
Secondly, when you have reference queries in Power BI, consider to use Table.Buffer() function to reduce the number that Power BI send request to data source. And use List.Buffer() function to imporve calculation performance.
To better use the DirecQuery mode, please review the tips in the article below.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#guidance-for-using-directquery-successfully
Regards,
Lydia
Anonymous
Thanks. That helps a lot.
schaema3,
If my reply solve your issue, you can accept my reply as answer to close this thread.
Regards,
Lydia
