Skip to main content
Microsoft Idea

    Power BI

    Under Review

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

    Vote (11) Share
    Boris Lipschitz's profile image

    Boris Lipschitz on 13 Aug 2015 08:05:49

    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.

    Comments (2)
    Boris Lipschitz's profile image Profile Picture

    Michal Morciniec on 05 Jul 2020 22:35:14

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

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

    Boris Lipschitz's profile image Profile Picture

    Colin Banfield on 05 Jul 2020 22:19:53

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

    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?