Category: <span>Power BI Desktop</span>

Power BI Desktop SQL Server

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To show the age of the index statistics when they were last captured. Sources This feature queries the DMV dm_db_stats_properties which returns the date of the…

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To get a baseline of the size of the tables in the databases. Sources This feature queries the DMV sys.dm_db_partition_stats which returns page and row-count…

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To get a baseline of the server wait statistics. Sources This feature queries the 2 DMV’s sys.dm_os_waiting_tasks and sys.dm_os_wait_stats which returns information about the wait…

Power BI Desktop SQL Server

Updated January 26, 2022. Purpose To provide a wrapper around the Who Is Active solution made by Adam Machanic. Sources When executing the stored procedure sp_WhoIsActive the result of who…

Power BI Desktop SQL Server