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: Getting Cross Domain Kerberos and Delegation working with SSIS Package

SQL Server Support Content

I started working on this issue started by way of a Twitter conversation between myself, Jorge Segarra ( @sqlchicken ) and Matt Masson ( @mattmasson ). I then found out that Jorge was working with a customer that had opened up a Support Case. Also ...read more

on 26 Jun 2014
Blog Post: Kerberos Configuration Manager updated for Analysis Services and SQL 2014

SQL Server Support Content

Kerberos Configuration Manager was released back in May of 2013. It initially released with only SQL Server support . This was followed up with support for Reporting Services in November 2013. You can download the latest release from the following ...read more

on 26 Jun 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: Analysis Services - Errors when trying to add a User as a Server Admin

SQL Server Support Content

When trying to add a user as a Server Admin to Analysis Services, you may encounter one of the following errors: The following system error occurred: The trust relationship between the primary domain and the trusted domain failed. (Microsoft.AnalysisServices ...read more

on 16 Nov 2012
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: Microsoft CSS @ PASS Summit 2012

SQL Server Support Content

This is a little later than we normally do it, but better late than never! During November 6th-9th, the US PASS Summit 2012 will be held in Seattle, Washington at the Seattle Convention Center. The Microsoft CSS team has a long history with ...read more

on 31 Oct 2012
Blog Post: Microsoft CSS @ PASS Summit 2013

SQL Server Support Content

During October 15th-18th, the US PASS Summit 2013 will be held in Charlotte, NC at the Charlotte Convention Center. The Microsoft CSS team has a long history with PASS. We have been speaking and working at PASS since 2003. This year ...read more

on 10 Oct 2013
Blog Post: SQL Connection Pool Timeout Debugging

SQL Server Support Content

This is a follow up to two blog posts from back in 2009 which talked about leaked connections. In Part 1 and Part 2 of that post, it was about how to determine that you actually filled your pool. This was centered around the following error ...read more

on 22 Oct 2013
Blog Post: FileNotFoundException with Microsoft.AnalysisServices.Xmla

SQL Server Support Content

I ran across two cases that were hitting the following Exception within SharePoint trying to run the PowerPivot Management Portal. This was located in the SharePoint ULS Log: EXCEPTION: System.IO.FileNotFoundException: Could not load file or assembly ...read more

on 5 Dec 2012
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: Invalid or loopback address when configuring SharePoint against a SQL Server

SQL Server Support Content

I was presented with a connectivity issue when trying to configure SharePoint 2013 using a CTP build of SQL 2014. They got the following error when they were it was trying to create the Configuration Database. Exception: System.ArgumentException ...read more

on 4 Oct 2013
Blog Post: AdomdConnectionException using PerformancePoint hitting Analysis Services

SQL Server Support Content

I was working with a customer who was encountering problems trying to use a PerformancePoint Dashboard against an Analysis Services Instance. The issue came down to the Claims to Windows Token Service (C2WTS) configuration. This is used to take ...read more

on 6 Sep 2012
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
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: Error trying to access SharePoint List from Power Query

SQL Server Support Content

When trying to pull data from a SharePoint List Data Source, using the Microsoft Online Services ID, you may see the following output in your query: DataFormat.Error: OData: The given URL neither points to an OData Service or a feed: ‘https://login.microsoftonline ...read more

on 8 Aug 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: Breaking Down 18065

SQL Server Support Content

We have had two blog posts on this blog regarding the 18056 error. Two from Bob Dorr (and part 2 ) and another from Tejas Shah . However, we still see a lot of questions about this error message. This error message can show up for different reasons ...read more

on 13 Feb 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: Getting Cross Domain Kerberos and Delegation working with SSIS Package

Blog Post: Kerberos Configuration Manager updated for Analysis Services and SQL 2014

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: Analysis Services - Errors when trying to add a User as a Server Admin

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: Microsoft CSS @ PASS Summit 2012

Blog Post: Microsoft CSS @ PASS Summit 2013

Blog Post: SQL Connection Pool Timeout Debugging

Blog Post: FileNotFoundException with Microsoft.AnalysisServices.Xmla

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

Blog Post: Invalid or loopback address when configuring SharePoint against a SQL Server

Blog Post: AdomdConnectionException using PerformancePoint hitting Analysis Services

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

Blog Post: Kerberos Configuration Manager updated for Reporting Services

Blog Post: Tracking down Power View Performance Problems

Blog Post: Error trying to access SharePoint List from Power Query

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

Blog Post: Breaking Down 18065