Identifying Slow queries in Excel PowerPivot

Technorati Tags: PowerPivot,SQL BI,Excel I had a very slow power pivot report and wanted to identify which query was taking the time so I enabled the tracing The trace is generated by default in your desktop, the trace is a SQL Profiler trace so you will need to use SQL Profiler to open it. When…

0

Updating a WCF Azure Service to SSL and Client Certificate authentication

  I created a WCF Service in Azure and started to use it, it started very simple but we added new features that need to be protected, so I started the journey of taking my simple WCF Service and configure it to use SSL and client authentication, one of the requirements was minimal downtime, so…

2

Console Hosted proxy to read performance counters from Azure into PowerPivot

  You can configure Windows Azure Diagnostics to collect the performance counters of your application and store it in the storage account, those counter will be available in the WADPerformanceCounters Table, there are third party tools and some blogs about how to consume this data but I wanted few features.   As fast as possible…

0

Refresh External Data in a Excel Power View workbook hosted on Office 365

One of the cool features of Excel is that you can publish your workbook to different places like SharePoint or even Office 365 , the nice thing about publishing in Office 365 is that usually you can share it with people across the world and accessing it without connection to your corporate network. Although there…

4

Using Power View in Excel with Reporting Services Reports as data source

  With the addition of Power View in Excel 2013 there are a lot of new things you can do, for instance I have a report with some data which I want to do data exploration. The right data is already  published in a report so I have two options: Check the report definition, view…

3