Browse by Tags

Blog Post: Power View in Excel won’t render from SharePoint

SQL Server Support Content

I originally encountered this issue back in May with a customer. We had another customer this month that had the same issue. When you try to load an Excel Document with a Power View Report in it from SharePoint, you may encounter the default ...read more

on 21 Aug 2014
Blog Post: How to grab multiple parent/child elements from XML Data Source

SQL Server Support Content

We had a question come up about why an XML query wasn’t pulling a 2nd Parent/Child element from the resulting data. This was grabbing data off of a Web Service. The example I was given was a public Web Service call for getting Weather information ...read more

on 29 Apr 2014
Blog Post: SharePoint Adventures : Using Claims with Reporting Services

SQL Server Support Content

Back in February of 2011, I created a blog that walked through using Kerberos with Reporting Services . Since then, we have moved Reporting Services to a shared service within SharePoint. This changes the game and we are now in the Claims world ...read more

on 28 Apr 2014
Blog Post: RS, SharePoint and Forefront UAG Series – Intro

SQL Server Support Content

I have been working a fairly complicated case over the last year that involved running Reporting Services Reports through a Universal Access Gateway (UAG) to publish a SharePoint Site. I worked with an engineer (Alejandro Lopez) in the SharePoint ...read more

on 23 Apr 2014
Blog Post: RS, SharePoint and Forefront UAG Series – Part 4 (Power View - Export to PowerPoint)

SQL Server Support Content

Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) Part 3 – Power Pivot Gallery (Silverlight) Part 4 – Export a Power View Report to PowerPoint (you are here) The last part of this engagement was when they tried to Export a Power View report ...read more

on 23 Apr 2014
Blog Post: RS, SharePoint and Forefront UAG Series – Part 3 (Power Pivot Gallery - Silverlight)

SQL Server Support Content

Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) Part 3 – Power Pivot Gallery (Silverlight) (you are here) Part 4 – Export a Power View Report to PowerPoint The last post really went into the meat of the issue that we had. ...read more

on 23 Apr 2014
Blog Post: RS, SharePoint and Forefront UAG Series – Part 2 (Operational Reports)

SQL Server Support Content

Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) (you are here) Part 3 – Power Pivot Gallery (Silverlight) Part 4 – Export a Power View Report to PowerPoint This piece took the longest amount of time to narrow down what was going ...read more

on 23 Apr 2014
Blog Post: Tracking down Power View Performance Problems

SQL Server Support Content

The scenario was that we saw sluggishness on the initial load of a Power View Report and also when we went to use one of the filters on the report - like a Pie Chart Slice. For the given report the customer had showed us, the initial load was taking 13 ...read more

on 29 Jul 2013
Blog Post: Getting a Power View report within Excel 2013 to work with SharePoint

SQL Server Support Content

I was setting up my SharePoint 2013 server to be able to use an Excel 2013 workbook that had a Power View Report in it. However, when I tried opening the workbook, I got the following error: In the ULS logs of my SharePoint server that had RS installed ...read more

on 9 Jan 2013
Blog Post: Power View display issues with Page Viewer Web Part

SQL Server Support Content

I ran into two separate issues this week that both dealt with displaying a Power View report through a Page Viewer Web Part within a SharePoint page in SharePoint 2013. The resolution to both were the same, so I thought I would lump them both into this ...read more

on 16 Aug 2013
Blog Post: SharePoint Adventures : When connectivity is not connectivity

SQL Server Support Content

I’m always amazed that issues usually come in batches. I was looped into a few cases that had the following symptoms. They were running SharePoint 2010 and Reporting Services 2012 SP1. When they went to use a data source with Windows ...read more

on 17 May 2013
Blog Post: Getting a SharePoint List Data Source to work with Reporting Services Native Mode

SQL Server Support Content

A case came up where the user was trying to use Report Builder in a Reporting Services instance that was not integrated with SharePoint. It was in Native Mode configuration. They indicated that they were getting a 401 error. My initial ...read more

on 11 Jun 2013
Blog Post: RS: Database Engine does not meet edition requirements

SQL Server Support Content

I've ran across the following error a few times and thought I would post this out there for people to understand what is happening. ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices ...read more

on 20 Feb 2013
Blog Post: SharePoint Adventures : Claims, Named Pipes and Kerberos

SQL Server Support Content

I ran into a new Kerberos Scenario that I hadn’t hit before when I was working on the cases related to this blog post . It’s rare that I actually see a case related to the Named Pipes protocol. When I do, it is usually a customer trying to get it ...read more

on 17 May 2013
Blog Post: Using PowerShell to discover Reporting Services 2012 in SharePoint

SQL Server Support Content

I was recently going through an exercise of documenting how to discover certain aspects of Reporting Services for some Kerberos work. RS 2012 in SharePoint is a totally different game though. The easiest way I could discover certain items ...read more

on 30 Apr 2013
Blog Post: Kerberos Configuration Manager updated for Reporting Services

SQL Server Support Content

Back in may, we released the Kerberos Configuration Manager tool to help with diagnosing and correcting Kerberos related issues for SQL Server. Today, I’m happy to announce that version 2 of this tool has been released and has been updated for Reporting ...read more

on 22 Nov 2013

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

Blog Post: Power View in Excel won’t render from SharePoint

Blog Post: How to grab multiple parent/child elements from XML Data Source

Blog Post: SharePoint Adventures : Using Claims with Reporting Services

Blog Post: RS, SharePoint and Forefront UAG Series – Intro

Blog Post: RS, SharePoint and Forefront UAG Series – Part 4 (Power View - Export to PowerPoint)

Blog Post: RS, SharePoint and Forefront UAG Series – Part 3 (Power Pivot Gallery - Silverlight)

Blog Post: RS, SharePoint and Forefront UAG Series – Part 2 (Operational Reports)

Blog Post: Tracking down Power View Performance Problems

Blog Post: Getting a Power View report within Excel 2013 to work with SharePoint

Blog Post: Power View display issues with Page Viewer Web Part

Blog Post: SharePoint Adventures : When connectivity is not connectivity

Blog Post: Getting a SharePoint List Data Source to work with Reporting Services Native Mode

Blog Post: RS: Database Engine does not meet edition requirements

Blog Post: SharePoint Adventures : Claims, Named Pipes and Kerberos

Blog Post: Using PowerShell to discover Reporting Services 2012 in SharePoint

Blog Post: Kerberos Configuration Manager updated for Reporting Services