Power BI User on 09 Jul 2015 12:35:38
Azure SQL and Azure DW Direct Query datasources are great, and this is most probably the future. There is however a requirement for a real-time semantic model in the middle. For example, this will be great for: captions/translations, attribute order by, hierarchies, images, relationships defined outside of the db, ... And most importantly that could provide a multidimensional query language (MDX and/or DAX). It could be Tabular in Azure or it could an in-database semantic model like SAP HANA?