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 que...

Anonymous

Not applicable

8 years ago

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

New Member

8 years ago

Anonymous

Thanks. That helps a lot.

Anonymous
Not applicable
8 years ago
schaema3,

If my reply solve your issue, you can accept my reply as answer to close this thread.

Regards,
Lydia

Forum Discussion

Loads and security concerns on "DirectQuery Connection"