Utilising SQL Server Stored Procedures with Power BI

Those who have experience working with an RDMS system like SQL Server will become accustomed towards a certain way of going about things. These can often involve a mixture of "lazy" query writing (e.g. using SELECT *... as opposed to SELECT Column1, Column2...), the manner in which you write your query (ALL CAPS or lower [...]

Becoming a Dynamics CRM/365 for Enterprise Swiss Army Knife: Essential Study Areas

Getting to grips with how to use Dynamics CRM/365 for Enterprise (D365E) is no easy feat. You can imagine just how difficult it is for an end user to get to grips with how the application works and functions; with more detailed knowledge around customisation and development being an entirely different ball game altogether. Compounding [...]

A New Template for Success? Word Templates vs. CRM Reports (Part 1)

For those who have done a lot of work previously creating bespoke document templates within CRM, the only effective way in which you would traditionally do this within CRM was via a Report. For the uninitiated, reports are .rdl files that are created within CRM (for very basic reports) or via SQL Server Data Tools [...]

To Online or Not Online: Factors to Consider when Comparing CRM Online/On-Premise

For those businesses or individuals who are currently considering Dynamics CRM, one of the decisions that you will ultimately need to make is regarding whether you intend to use CRM Online or CRM On-Premise. For those whose first reaction to the previous statement is "Say what?", heres a brief breakdown of the two different options: [...]

How to embed a non-CRM SSRS Report into a CRM Form

The Scenario: You are running CRM Online in conjunction with some legacy database/application systems. These systems are setup with a SQL Server Reporting Services instance that is looking to either an SQL Server, OLE DB etc. database. The Problem: You need to make data from your legacy systems visible within your CRM. The information needs [...]