SharePoint - Back to basics - Display data in groups and sorting in SharePoint data grid view

We can use data view web parts to display data for adding different feature to show our list data. We can display groups and sorting by using data grid view web part. By using grouping sorting options in grid view we can display the item group wise

To add Data View web part to SharePoint page open SharePoint page in designer and in insert tab click on Data View Web part. Add Empty data view web part to the page.

Select the list to add the data view web part by clicking on “Click here to select data source” link in the web part.

We can see the pop up with all the lists in the site. Select the list.

In the right side pane, select multiple view to see all the items in the web part.

We can add/remove the columns to the web part by click on “Add or Remove columns” in the top ribbon. We can sort and group the data by clicking the “Sort and Group” option in top ribbon.

By clicking on the “Sort and Group” option we can see a pop up to add sorting and grouping columns.  We can have the options to collapse and expand the grouping in “Group Properties” section. Also we can edit the sort expression to display the items.

By checking “Sort & Filters on headers” we can provide sorting and filtering options as regular list columns. We can add Grouping tool bar for data view web part by selecting the options tab as shown in the image below.

After all we can see the data with grouping and sorting. 

SharePoint 2013 wsp upgrading error: Cannot uninstall Language Pack 0 because it is not deployed when attempting to uninstall-spsolution.

While updating a wsp in SharePoint 2013 environment I got an error saying that “Cannot uninstall Language Pack 0 because it is not deployed when attempting to uninstall-spsolution.” As shown the image below.

By checking the solution in farm solutions (Central Administration -> System Settings -> Manage Farm Solutions) Solution wasn’t deployed. I have found this blog explaining the issue. The reason for this error is that DLL’s in the GAC were not able to delete. So I have deleted the DLL’s in the GAC and deployed through SharePoint central Administration

If it is timer job, We have to Stop and SharePoint timer services in the services.

Hope this helps.

PowerShell Scheduled Data Refresh – Call to Excel Services Returned an error

In SharePoint Power Pivot data Automatic refresh from excel services, I got an error saying that “Power Pivot Scheduled Data Refresh – Call to Excel Services Returned an error” as shown the image below

By digging into the issue I have found that I don’t have permissions for Power Pivot service. To fix the issue we have to add the permissions for Power Pivot. To add we need to give the account running Power Pivot Full Control to the Web app under the Policy for Web Application.

Hope this helps.

SharePoint Usage and Health Data Collection Error - “There is no data available for this report. Here are some possible reasons - Web Analytics has not been enabled long enough to generate data”

While checking the usage health reports for a SharePoint site, I got an Error Saying that “There is no data available for this report. Here are some possible reasons: (1) Web Analytics has not been enabled long enough to generate data; (2) There is insufficient data to generate this report; (3) Data logging required for this report might not be enabled; (4) Data aggregation might not be enabled at the level required for this report.”

After checking that one by one in the issues

• I am having full of data in SharePoint site and that is fair enough to generate the data reports.
• In the site I am sure that Data logging and Data Aggregation are enabled. I was checked that also as part of trouble shooting. Web Analytic are also enabled as mentioned in the issue.

After pulling hair and digging into the deep, I have found that Usage and Health Data Collection Service Application Proxy has not been started. Silly, but I have spent so much of my time. After starting the service proxy by using following Power Shell command everything working as expected.

$usageHealthDataServiceProxy = Get-SPServiceApplicationProxy | where {$_.DisplayName -eq “Usage and Health Data Service”}

$usageHealthDataServiceProxy.Provision()

Hope this helps.

SharePoint Power view error: There are no addresses are available for this application

Working with SharePoint power view I got an error saying that “Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application.”

Checking the error I have found that we have to run SQL Server Reporting service, Manage metadata service and user profile services. We have to make sure that they are running properly. To do that navigate to SharePoint Central Administration, Application Management section. Click on Manage Services

Check for SQL Server Reporting service, Managed meta data service and User profile services are started or not. If not started Start the services. Reset IIS manager (IISRESET)