Forum Discussion
Speed Up Power Query Refreshes (Data from DevOps)
I have a workbook with a query that hooks up to my data in DevOps for Work Items (approximately 10,000 records). The query brings back about 20 columns from the table (and expanded tables - e.g. proj...
I would reccomend you to start by running a diagnostic on the query to find where its the performance being affected at, the source? a step? evaaluation? etc.... theres a tool for this inside power query will give you a starting point to look and you can share here your run results for a better answer or asistence, check this link:
https://docs.microsoft.com/en-us/power-query/querydiagnostics