Forum Discussion
Loads and security concerns on "DirectQuery Connection"
Hi,
I have a concern/ question about loads and security of "DirectQuery Connection".
I did not find any topics around this issue. So i ask it here. My questions are:
1- When we have many queries on many tables for BI purposes, is there any risk for throwing loads on server and under effect delivering services from that server?
2- Is there any concern of abusing this connection and be able to edit/ delete or manipulate databases in any way?
Looking for your Answers.
Best Regards
Hirad Karimi
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
3 Replies
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,
LydiaAnonymous
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
