Add indicators to what portion of the queries are executed in memory and what on SQL Server

[borlip]

There should be also some colourful indicators about what steps are running in memory and what are running on the server. Also should be some indicators about how much data is pulled from the server in (MB). Power BI is meant to be used by non-technical people but they can cause big damage to the performance of SQL Server, Network, etc.

[colinbanfield1]

Great suggestion. I once suggested the creation of a log file when query folding occurs. Currently, there's no way to know what folded and what didn't, or if anything folded at all. Do all databases have a query profiler? Do all developers have access to this tool if one is available?

[micham]

Having the ability to view information regarding to query performance end to end in the PowerBI Portal would be valuable. How much time is spend on Portal, time to gateway, Gateway to SQL server (or datasource generally) on the way out and back (for direct query).