Display Alternate text when a image URL is not present in Power BI

 

This video describes how to display alternate text when there is no data present for the image URL in Power BI.

Display default image when there is no data present for the image URL in Power BI

 

This video describes how to display a default image when there is no data present for the image URL in Power BI.

Display URL's as images in Power BI

 

This video describes how to display URL's as images in Power BI.

Connect to Azure Data Lake from Power BI

This video describes how to connect to Azure Data Lake from Power BI.

Download link to Azure Open Datasets: 

https://docs.microsoft.com/en-us/azure/open-datasets/dataset-catalog

T-SQL to find Server and SQL restart date time

This script comes handy when you would like to find out the Server and SQL services restart times.

DECLARE @SQLServiceRestartDateTime AS VARCHAR(50),
		@ServerRestartDateTime AS VARCHAR(50)

SELECT @SQLServiceRestartDateTime = create_date FROM sys.databases WHERE database_id=2
SELECT @ServerRestartDateTime = CAST(DATEADD(SECOND, (ms_ticks/1000) * -1, GETDATE()) AS datetime) FROM sys.dm_os_sys_info

SELECT @SQLServiceRestartDateTime AS [SQL Service Start DateTime], @ServerRestartDateTime AS [Server Start DateTime]