Azure BI

Note: see this article [https://myghost.azurewebsites.net/2015/09/29/pushing-data-thru-azure-stream-analytics-to-power-bi-part-4/] for some new insights. In part 1 [https://myghost.azurewebsites.net/2015/03/30/pushing-data-thru-azure-stream-analytics-to-power-bi-part-1/] I provided an overview of the given solution. And now it is time to configure Azure Service Bus, Event Hubs and Stream Analytics to be able to sent and receive messages. I still be using the ‘old’ Azure Management Portal as I

Note: see this article [https://myghost.azurewebsites.net/2015/09/29/pushing-data-thru-azure-stream-analytics-to-power-bi-part-4/] for some new insights. Since the beginning of this year a new version of Power BI has been release in preview and since half March this version is available worldwide. One new feature of this preview is that there is now an API [http://docs.powerbi.apiary.io] to push data programmatically to Power BI. While pushing this data the dashboard based on the dataset is al

Last week I was challenged by a co-worker: *‘create a way that a tabular cube case serve a YTD value for different time hierarchies.’ *Because I work at a retailer at this moment, there is a fiscal calendar and a 454 calendar, which of course doesn’t align in the begin and end date. While I was writing this post, Marco Russo wrote a great post on how to createdifferent xTD values. Please read it: http://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/ (Note to myself: do not postpo

Adding trendlines to PowerPivot It started during a presentation of Cathy Dumas [http://cathydumas.com/] at the latest SQLBits [http://sqlbits.com/] where she compared the different charting capabilities of Excel, Power View, PerformancePoint and Reporting Service. One of those capabilities were trendlines who are missing in V1 of Power View. She suggested to add a trendline as a measure, but didn’t succeed, so she raised a challenge. And here I am taking this challenge to add a trendline to a P