Time Intelligence Calculation YTD & YOY (Datawarehouse vs MDX vs DAX)
In my last BI workshop we had the discussion whether or not it is worth the effort to create a BI-semantic Model on top of the Datawarehouse. I would like to share the answer: In order to achieve the following Report: from your Datawarehouse without a BI-Semantic Model you will Need the following T-SQL Code:
How to upload a file to Windows Azure Blob Storage with C# .Net described in a single Picture.
A workaround to use Power Query with SSIS Script Task
M is quite a nice language for Self Service ETL. The logical next step would be to include the Power Query functionality as a component in SSIS. As of now there is just the following Workaround. (Which is btw not supported but works quite well.) Create an Excel Workbook that contains the M-query and loads