Sure you can. Azure Stream Analytics supports Azure SQL Database as a source of input for reference data. You can use SQL Database as reference data for your Stream Analytics job in the Azure portal and in Visual Studio with Stream Analytics tools. This article demonstrates how to do both methods.
Now that you have defined Azure SQL Database as a source for Azure Stream Analytics, you can then add Power BI on the scenario for the real-time streaming dashboard as explained here.