Follow Us:
We are pleased to present below all posts tagged with 'power pivot'. If you still can't find what you are looking for, try using the search box.
Welcome back to part 2 of my review of tips and gotchas for using Power Query with Dynamics CRM OData feeds. Let’s continue our review and talk about how ugly the option set numeric values are, and how you can improve your query times by tweaking (filtering more specifically) the OData URL used in Power Query.
If you have been following the Excel business intelligence space lately, you are familiar with all of the slick add-ins Microsoft has introduced with Power Query, Power Pivot and Power Map. We work with a lot of Dynamics CRM clients, and I recently set out to use some CRM Online data to create some visualizations and dashboards in Excel. I encountered a few different situations I had to deal with, so in this post I want to walk you through some of the gotchas I found when you use Dynamics CRM data with Power Query.
When working with SharePoint, you occasionally need to work with related data. Since SharePoint isn’t setup for true relational data, that means we’re typically working with lookup columns from a child to a parent list. This is all fine well and good, but I had a client ask me for some special filtering and output with this related data. After reviewing my options, I found that the quickest way to do this (in under 15 minutes) is to use Microsoft’s Power Pivot add-in for Excel. No SharePoint Designer required! If you have Excel 2010, you will need to download and install the add-in. If you use Excel 2013, the add-in is already installed, you just have to enable it.
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
Request Download
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.