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
Troubleshooting PowerPivot workbook data source issues in Performance Point Services 2013
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. […]
External data refresh failed error for PowerPivotExcel Services
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 […]
Install SSRS 2012 SP1 in SharePoint 2013 mode
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 SP1 InfoPath Forms data connection taking too long to load data
Run the PowerShell script below $f = Get-SPInfoPathFormsService $f.Properties.Add(“AllowEventPropagation”, $false) $f.Update() References:
PowerPivot for SharePoint 2013 – Installing, configuring and verify
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 […]
Handling data in large external list – SQL Server
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 […]
PerformancePoint Services – SSAS Cube, SSRS Report, Decomposition Tree, Filter webparts, Graphs and Reports
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 […]
SSRS 2012 Content Types missing in Site Content Types
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 […]
Date Time value not matching with SQL DB value in SharePoint External List
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 […]