Users cannot see data in the Blocking (Current) dashboard and there is no data in the SQL PI dashboard when the monitored user is not and Administrator and the database is DTU and the service tier is basic, standard s0 or standard s1.
An error similar to the following may appear
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is: com.quest.qsi.fason.framework.connections.common.exceptions.JDBCServerException: Failed to run CURRENT_BLOCKING collection. Failed to execute query on database [HOSTADDRESS-DBNAME], user account [USERNAME]. Reason : [[Foglight][SQLServer JDBC Driver][SQLServer]VIEW SERVER STATE permission was denied on object 'server', database 'master'
