Poor performance when direct querying to an Azure SQL DW

Hi guys,   I am currently working on a project for a client. They have an Azure SQL DW, which stores data from numerous censors in a building they own. We are talking about several 100 million rows...