• How To Reopen Closed Activities in Microsoft Dynamics CRM 2013 with Bookmarklet

      Paul Nieuwelaar, 18 November 2014

      In Microsoft Dynamics CRM, once an activity has been closed, unlike most other entities, there’s no button to reactivate it. This means that if an activity is accidently closed, or if we want to modify some fields after it’s closed, we simply cannot. One way to reactivate the activity is

      Read the full article here
    • Dynamics CRM 2013/2015 Open Lookup in New Window Bookmarklet

      Paul Nieuwelaar, 13 November 2014

      In Dynamics CRM 2013, and also CRM 2015, when we click on the link in a lookup field, the record opens. However, because of the flat UI introduced with CRM 2013, the record opens in the same window as the record you’re currently on. In other words, you’re forced to navigate away from the

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 12

      Colin Maitland, 12 November 2014

      This blog is Part 12, in a series on creating reports using PowerBI tools such as PowerPivot, Power View and Power Map in Microsoft Excel for a Microsoft Dynamics CRM Online Organisation. In this blog and the next I will demonstrate how to transform the Option Set column Values into their correspo

      Read the full article here
    • Dynamics CRM Retrieve Statistics of Sandbox plugins

      Ahmed Anwar, 11 November 2014

      Microsoft Dynamics CRM 2013/2011 collects useful information about executed plugins which are registered in the Sandbox mode. Approximately, every hour, CRM generates a record of type PluginTypeStatistic. The generated record produces information about the average execution time of each plugin and h

      Read the full article here
    • Dynamics CRM Retrieve Statistics of Sandbox plugins

      Ahmed Anwar, 11 November 2014

      Microsoft Dynamics CRM 2013/2011 collects useful information about executed plugins which are registered in the Sandbox mode. Approximately, every hour, CRM generates a record of type PluginTypeStatistic. The generated record produces information about the average execution time of each plugin and h

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 11

      Colin Maitland, 09 November 2014

      In my previous blog, of this series on using Power BI with Microsoft Dynamics CRM Online, I demonstrated how to reduce the number of rows in a Microsoft Dynamics CRM Online ODataSet using the Power Query Editor. In this blog I will demonstrate how to now apply sorting. The options sorting allow yo

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 10

      Colin Maitland, 05 November 2014

      In this series of blogs on using Power BI tools in Microsoft Excel to work with ODataSets downloaded form a Microsoft Dynamics CRM Online Organisation, I have so far demonstrated how to connect to the Microsoft Dynamics CRM Online Organisation; select one or more ODataSets, such as AccountSet, Conta

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 9

      Colin Maitland, 04 November 2014

      As a part of this series on creating Power BI reports for a Microsoft Dynamics CRM Online Organisation, I demonstrated in my previous blog how to expand the opportunity_customer_accounts relationship column in AccountSet. After being expanded however, an error occurred when the updated AccountSet wa

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 8

      Colin Maitland, 03 November 2014

      In my previous blog in this series on Power BI and Microsoft Dynamics CRM 2013, I demonstrated how to expand Option Set, Lookup and Money columns in the Power Query Editor. In this blog I will demonstrate how to expand Parent/Child relationship columns using the opportunity_customer_acocunts re

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 7

      Colin Maitland, 02 November 2014

      In this series of blogs I am providing a simple overview of how to connect Microsoft Excel to a Microsoft Dynamics CRM Online Organisation and how to use some of the Power BI tools in Microsoft Excel.  In my previous blog I demonstrated how to use the Power Query Editor in Microsoft Excel

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 6

      Colin Maitland, 22 October 2014

      In this blog I will demonstrate how to reduce the number of columns in the Microsoft Dynamics CRM Online AccountSet, ContactSet and OpportunitySet OData Sets previously loaded into the Data Model in Microsoft Excel. This is an important initial step in the preparation of the OData Set queries for us

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 5

      Colin Maitland, 21 October 2014

      In this series of blogs I am providing a simple overview of how to connect Microsoft Excel to a Microsoft Dynamics CRM Online Organisation and how to use some of the Power BI tools in Microsoft Excel, such as Power Query, Power View, PowerPivot and Power Map, to create some nice looking, interactive

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 4

      Colin Maitland, 20 October 2014

      In my previous blog I demonstrated how to configure Power Query options and how to select and load one or more ODataSets from a Microsoft Dynamics CRM Online Organisation using Power Query in Microsoft Excel. In this blog I will demonstrate how to view and configure the relationships between th

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 3

      Colin Maitland, 19 October 2014

      In my previous blog I demonstrated how to create a connection in Microsoft Excel Professional Plus 2013 to a Microsoft Dynamics CRM Online Organisation for use by the Microsoft Excel Power BI tools such as Power Query, PowerPivot and Power Map.  In this blog I will describe how to configur

      Read the full article here
    • Power BI Microsoft Dynamics CRM 2013 – Part 2

      Colin Maitland, 15 October 2014

      In my previous blog I showed some samples of Power View, PowerPivot and Power Map reports that displayed Account and Opportunity related information retrieved from a Microsoft Dynamics CRM Online Organisation. In this blog I will provide a list of the supported versions of Microsoft Excel, the

      Read the full article here