I work for a large global organization that has our consolidated NAV database centrally located with all units accessing via Citrix connections to the dbs. Our IT department is discouraging the use of PowerQuery for data connection due to fears of database performance issues. My understanding is that PowerQuery only uses the power contained within the machine that runs the query (ie desktop), and should have no effect on the dbs that created the tables being queried. I am trying to determine if increased instances and/or size of data-pulls with PowerQuery will affect dbs performance?
Hi Jay,
If you mean a Dynamics NAV database, then Power Query will push the work back to the database, rather than the PC taking the load. This is known as query folding.
You can prevent Power Query doing this by pasting your SQL statment into the advanced options filed. i.e. Get Data > From SQL Server Database > Advanced Options.
This assumes you're not using Dynamics 365 service which is online.
Mynda
