Microsoft 'Connects' Power BI and Dynamics CRM Online
Users of Microsoft's Excel-based business intelligence tool can now quickly incorporate Dynamics CRM Online data into their insights-gathering efforts.Microsoft is making it easier for Power BI users to glean business insights from Dynamics CRM Online, the company's cloud-based CRM software suite, and unearth potentially business-boosting trends from their organizations' customer interactions. "This month, we are introducing a new connector for Dynamics CRM Online," announced the Microsoft Excel Team in a blog post. "Until now, you were able to connect to Dynamics CRM Online using the OData feed connector; however, this was not very discoverable for the majority of our users." Dynamics CRM Online now appears under the "From Other Sources" in Excel Power Query, requiring users to input a valid URL to their account, followed by their credentials. Power Query is an Excel add-on that links to Power BI, the company's Azure -backed business intelligence and analytics solution for Office 365, and enables rank-and-file employees to explore data using the spreadsheet software's familiar interface and toolset. "Once the user is authenticated, Power Query retrieves the list of tables and entities available in Dynamics CRM," added Microsoft's staffers. "The Navigator task pane displays this list and users can select one or multiple items, edit these items or load them to the workbook—just like with any other data source in Power Query."
Since its debut more than a year ago, Microsoft has been working to expand Power BI's reach and provide organizations with user-friendly methods of deciphering analytical data. In December, the company rolled out a preview of Power BI dashboards, a new feature that consolidates multiple visualizations into a single view. Dashboards can include graphs, charts and other visualizations from a mix of data that resides on-premises and in the cloud.