Follow Us: facebook twitter linkedin

Posts Tagged 'OData'

We are pleased to present below all posts tagged with 'OData'. If you still can't find what you are looking for, try using the search box.

Gotchas When Using Power Query to Retrieve Dynamics CRM Data – Part 2

imageWelcome 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.

Gotchas When Using Power Query to Retrieve Dynamics CRM Data – Part 1

imageIf 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. 

    Bad OData Calls Potentially Causes CRM Service Problems

    In the movie Star Wars Chancellor Palpatine outwardly appears to be a well-intentioned and loyal public servant and supporter of democracy, yet underneath his affable public persona lurks his true identity. His Sith name was Darth Sidious and accurately describes his true hidden nature. In a CRM project of any size you may end up with a decent amount of JavaScript to implement client side form customizations. Most likely there will be a need to make web service calls to get certain pieces of information about things such as the user, his/her roles, etc. You have to make sure your web service calls are being made correctly or else you could run into some "insidious" problems on your server.

     

    A Quick Look at OData

    SharePoint 2010 and the upcoming Dynamics CRM 2011 are two of Microsoft's premier products that are leveraging the new Open Data protocol,or OData. At C5 Insight, we focus on SharePoint and CRM, so we're excited about diving into OData and finding ways to use it to enhance our clients' investments in these systems.

    Blog Topics

    1
    Image

    CPR for CRM Study

    The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.

    2
    Image

    SharePoint Readiness Assessment

    This 60-second assessment is designed to evaluate your organization's collaboration readiness.

    3
    Image

    CRM Self Assessment

    Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.

    4
    Image

    SharePoint Feedback Solution

    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.

    9
    Image

    SharePoint Upgrade Checklist

    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.