Avtex is Opening a Global Delivery Center
by George Demou
Creating and sharing Power BI reports are a powerful new way to work with Microsoft Dynamics 365 data. As a tightly coupled cloud service, Power BI works with Microsoft Dynamics 365 to provide data analytics and highly informative, actionable, and interactive data visualizations.
As discussed in a previous blog, the easiest way to get started using Power BI with Microsoft Dynamics 365 is to use the freely available Content Packs. Microsoft Power BI has a desktop application for when more advanced and customizable data analytics are required.
If you would like to deploy Power BI tiles, reports, and dashboards to Microsoft Dynamics 365, first allow Power BI within the Microsoft Dynamics 365 instance.
Before connecting Power BI and Microsoft Dynamics CRM Online you will need to gather some information from your Microsoft Dynamics CRM Online instance.
Note: Connecting to Microsoft Dynamics CRM Online presently can only be achieved using Power BI Desktop and then published to Power BI Online.
5. Copy the Instance Web API Service Root URL into the URL box and click OK.
a) The API URL will come in the form: https://OrganizationName.api.crm.dynamics.com/api/data/1
6. In the Access an OData feed screen, select Organizational Account on the left then click Sign in button, enter your credentials, and sign in. Once signed in you will be returned to the Access OData Feed screen. Now click Connect.
a) Note: If you are already signed in, simply click
b) Note: Connecting may take several minutes as it creates the data set within Power BI Desktop.
7. The Navigator window will now be available to select which Dynamics 365 tables you would like to use to build your data model.
Once the data schema is available, you can now create powerful reports and data sets. Data from other systems may be integrated with the Dynamics 365 data to allow reporting across your Enterprise applications and data sets. Whether you choose to create reports or simply build the data model for Power BI users, you are now ready to publish your report and data sets for organizational sharing and access from anywhere on most any device. On the Power BI Desktop main page Home tab ribbon, click Publish. It is as simple as that.