Power View connection error – Resolved

When you’re starting off to create a visualisation in Power View, you might notice the following error:


http://www.microsoft.com/sql/reportingservices”>An error occurred while loading the model for the item or data source ‘http://sapphire/PowerPivot Gallery/HelloWorldPicnicPowerViewTutorialRC0.xlsx’. Verify that the connection information is correct and that you have permissions to access the data source.

When you read down to the foot of the error message, the error message becomes more specific. Here is an example:

A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running.

When you start up the ‘SQL Browser’ service, then the Power View visualisation works.  The SQL Server Browser operates as a Windows Service. It has two main roles: it listens for incoming requests for Microsoft SQL Server resources, and it provides information about SQL Server instances installed on the computer. If it isn’t running, then the connection fails since the data source can’t be found.

Leave a Reply