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 hereIn 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 hereIn 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 hereIn 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 hereIn 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 hereIn 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 hereDynamics CRM only accepts files up to 8MB. We can change this limit using an unsupported technique, however with Dynamics CRM Online we cannot do this. So, the only way to import large datasets is to either manually break that large file into smaller files by copying, pasting and saving new files or
Read the full article hereIn 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 hereIn this series of blogs I will provide a simple overview of how to connect Microsoft Excel to a Microsoft Dynamics CRM Online Organisation and how to then use some of the Power BI tools in Microsoft Excel, such as Power Query, Power View, PowerPivot and Power Map, to create nice looking, interactive
Read the full article hereLast year we created the Dynamics CRM 2013 Left Navigation. This changed the new navigation that came with Dynamics CRM 2013 to return to a vertical layout, including a scrollbar and also being more “sticky”. We’ve made couple of improvements, you can now install this as a solution
Read the full article hereCurrently in Dynamics CRM 2013 using the CRM for tablets app, the only dashboard that is available to view in the app is the Sales Dashboard, which was a special dashboard introduced with the release of the CRM for Tablets app. Now however with Dynamics CRM 2015 and enhancements to the Dynamics CR
Read the full article hereIn Dynamics CRM every now and then users may encounter errors like the one below. These are typically random errors with Microsoft scripts that usually do not affect any functionality. We’re prompted with the option to ‘Send Error Report’ to Microsoft so they can fix the bug if e
Read the full article hereIf you’re seeing an error similar to the one above, you’ve probably done a database backup and restore from a Dynamics CRM 2013 instance into a new Dynamics CRM 2013 or 2015 instance. This error will pop up when you try and modify a user’s email address, or open personal options f
Read the full article hereMicrosoft Dynamics CRM 2013 provides a number of Windows PowerShell cmdlets that may be used to manage a Microsoft Dynamics CRM 2013 deployment. These cmdlets are available on the Microsoft Dynamics CRM 2013 Server which has the Deployment Tools Server Role installed. In order to use the cmdlets you
Read the full article hereIf you’ve recently upgraded to CRM 2013 SP1 and you’ve applied the product update for cases, you might be experiencing an issue where outlook users are unable to track certain emails in CRM. They receive an error: You do not have permissions to access these records. Contact your Microsof
Read the full article here