Power BI Dynamics CRM Online Connector

In February, Microsoft released a new version of the Power BI Designer Preview. If you haven’t heard of Power BI, it’s a business intelligence platform that helps make sense of your data through robust querying and reporting features. If implemented correctly—xRM (www.xrm.com) can help with implementation—your team can make effective decisions more quickly than ever before. The idea is to host these reports on a SharePoint site where members of your team can interact with the data.

The Power BI Designer Preview is a client that you can download for free and try yourself. This is the tool that allows you to connect to your database, query the relevant data, and design the reports. Up until now, connecting to a CRM Online database was a little tricky. With the latest update, it’s easier than ever.

From the open Power BI Designer Preview client, click the New Source button in the ribbon.

Power BI Dynamics CRM Online Connector

The Get Data window opens. Select Other > Dynamics CRM Online, and then click Connect.

Power BI Dynamics CRM Online Connector

You are then prompted to provide the URL for the Dynamics CRM OData service.

Power BI Dynamics CRM Online Connector

Where can you find that URL? It’s actually not difficult, and you do not need administrative privileges in CRM Online to find it. In CRM Online, navigate to Settings > Customization > Customizations and click Developer Resources. You are taken to a page that has your organization information. At the bottom is the Organization Data Service section. In it is a link, which is your OData service. You can copy the link, or click it, which opens a new tab. The URL in the address bar of the new tab is your OData link as well. Copy and paste it into the Power BI Designer and then click OK.

The Power BI Designer will then connect to your database and detect the tables of data in it. You can then select the tables you wish to work with, define your queries, and build your report.

Power BI Dynamics CRM Online Connector

If you would like to learn more tips, tricks, and tutorials such as this one, please check out our xRM blog and our Success Portal. If you would like to receive training from our team of experts, please inquire about our QuickStart Training.

Read More

CRM Online 2015 Update 1 Videos

Microsoft recently released some new YouTube videos on its Microsoft Dynamics channel in anticipation of Microsoft Dynamics CRM Online 2015 Update 1. Unfortunately, the videos aren’t collected in a playlist specific only to Update 1 differences. Don’t worry! xRM (www.xrm.com) has organized a subset for you below. Note: Update 1 will be made available only for CRM Online 2015 first and will be made available for on-premises deployments later.

CRM Online 2015 Update 1 Videos

New navigation for Microsoft Dynamics CRM Online – Hooray! Navigation is easy again in Update 1. (Readers who used to use version 2011 know what that means.)

Theming with Microsoft Dynamics CRM Online 2015 Update 1 – Have you ever wanted to change the colors of CRM Online or add your own company logo? Now you can.

Overview of Mobile Application for Smart Phones for Microsoft Dynamics CRM Online 2015 Update 1 – Access records on the go.

Extend Dynamics CRM to your Smart Phone with CRM Online 2015 Update 1 – Customize what you can do with CRM Online on your mobile device.

Read More