Browse by Tags

Tagged Content List
  • Blog Post: Copying PowerPivot tables between Excel workbooks to consolidate Power View Reports

    I use multiple Excel PowerPivot models created in different workbooks by multiple people, sometimes I need to mash up them or simply create a single workbook with all the models so I can share it easily in my Office 365 site I tried opening the PowerPivot add in and realized that there is not option...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 the data source...
  • Blog Post: How to refresh a Tabular Model

      Power View works with tabular models, the most easy way to work with them is to use the PowerPivot gallery in SharePoint and publish a Excel File with a PowerPivot model to create a Power View report on top of it, from there you can easily setup the data refresh using the SharePoint UI, there...
Page 1 of 1 (5 items)