Skip to content
Sandeep Nakarmi

Sandeep Nakarmi

SharePoint / Business Intelligence Specialist

  • Home
  • Blog
  • Contact Me

Author: Sandeep Nakarmi

CAML Designer 2013

April 3, 2017 Sandeep Nakarmi

Revamped CAML Designer. Very useful tool when working with CAML queries. Works for both On Permise SharePoint and O365. Intro to CAML Designer 2013 Download Link

 O365, SharePoint, SharePoint 2013, SharePoint Online, tools

Troubleshooting PowerPivot workbook data source issues in Performance Point Services 2013

March 29, 2015 Sandeep Nakarmi

​​Environment: SharePoint Server 2013 SP1 SQL Server 2012 SP1 While getting Performance Point 2013 to use PowerPivot workbook as as data source I came across this issue where I was when giving correct connection string it was still unable to use the workbook.​ […]

 PerformancePoint Services 2013, PowerPivot for SharePoint 2013

External data refresh failed error for PowerPivotExcel Services

March 23, 2015 Sandeep Nakarmi

Issue: You get the following error: An error occurred while working on the Data Model in the workbook. Please try again. We are unable to refresh one or more data connections in this workbook. Depending on what data provider you are […]

 PowerPivot for SharePoint 2013

Install SSRS 2012 SP1 in SharePoint 2013 mode

November 21, 2014 Sandeep Nakarmi

We'll install the SSRS 2012 SP1 SharePoint mode in PROSP13SRV02 which is going to host most of BI service applications. This server is not meant to serve user requests hence we'll not install SSRS add-in in this machine. We'll install […]

 SharePoint 2013, SSRS

SharePoint 2013 SP1 InfoPath Forms data connection taking too long to load data

November 20, 2014May 3, 2015 Sandeep Nakarmi

Run the PowerShell script below ​$f = Get-SPInfoPathFormsService $f.Properties.Add(“AllowEventPropagation”, $false) $f.Update() References:

 InfoPath, SharePoint 2013

PowerPivot for SharePoint 2013 – Installing, configuring and verify

November 19, 2014 Sandeep Nakarmi

SQL Server 2012 SP1 Analysis Server in SharePoint mode runs outside a SharePoint 2013 farm. Analysis Services server can be installed on a server that is part of the SharePoint farm but the Analysis Services is not dependent on services […]

 PowerPivot for SharePoint 2013, PowerView, SharePoint 2013, SSAS

Handling data in large external list – SQL Server

October 9, 2014 Sandeep Nakarmi

When you define external content type you are recommened in sharepoint designer to set a limit ​filter which essentially controls the number to items being returned to external list. The standard limit for this type of filter is 2000. You could potentially […]

 BCS

PerformancePoint Services – SSAS Cube, SSRS Report, Decomposition Tree, Filter webparts, Graphs and Reports

September 28, 2014 Sandeep Nakarmi

PerformancePoint Services can lookup to many data sources incliding SSAS cubes, and one great feature you get when you integrate it with cubes is Decomposition Tree. Decomposition Tree allows you to explore your cube in a visually intuitive way where […]

 Decomposition Tree, PerformancePoint Services 2013, SSAS, SSRS

SSRS 2012 Content Types missing in Site Content Types

September 26, 2014 Sandeep Nakarmi

If you come across a issue where you can't see SSRS Content types in your site, then first thing to try would be to deactivate and active the site collection feature "Report Server Integration Feature". If you still have issues […]

 SSRS

Date Time value not matching with SQL DB value in SharePoint External List

September 24, 2014 Sandeep Nakarmi

When you create an external content type using SharePoint Designer and it involves Date Time fields, than one thing you would need to consider is how date time values are handled in external content type. If you've just configured external […]

 BCS

Posts navigation

Recent Comments

  • Sandeep Nakarmi
    Sandeep Nakarmi on Create external lists with foreign key association and use user friendly column names
  • vikas on Create external lists with foreign key association and use user friendly column names
  • David Moore on SharePoint Site Provisioning
  • John on Promoting Image metadata values to SharePoint Asset Library
  • John on Promoting Image metadata values to SharePoint Asset Library

Categories

  • BCS (4)
  • Decomposition Tree (1)
  • External List (1)
  • InfoPath (5)
  • Javascript (1)
  • O365 (1)
  • PerformancePoint Services 2013 (3)
  • PowerPivot for SharePoint 2013 (3)
  • PowerView (1)
  • Secure Store (1)
  • SharePoint (6)
  • SharePoint 2003 (1)
  • SharePoint 2007 (8)
  • SharePoint 2010 (21)
  • SharePoint 2013 (9)
  • SharePoint Designer (1)
  • SharePoint Online (3)
  • SQL (2)
  • SSAS (3)
  • SSRS (3)
  • tools (1)
  • Uncategorized (1)
  • Virtual Machine (1)
  • Visio (1)
  • Visual Studio (5)
  • WCF (1)

Tag Cloud

browser form caml caml desginer column limit dispose objects feature stapling field names field validation image metadata infopath KMZ list data validation lookup list migration; o365 Office 365 permission kind property promotion reflector RPC sharepoint sharepoint 2007 sharepoint online site provisioning site template solution spdisposecheck virtual box WCF web service

Archives

  • Twitter
  • LinkedIn
© 2014 SandeepNakarmi.com | Powered by WordPress | Theme Amplify
SiteLock