Вернуться   AXForum > Microsoft Dynamics CRM > Dynamics CRM: Blogs
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 11.08.2018, 01:21   #1  
Blog bot is offline
Blog bot
24,301 / 817 (76) +++++++
Регистрация: 28.10.2006
powerobjects: Introduction to Power BI

Power BI is a Business Analytics tool that provides interactive visualization and allows end users to create reports and dashboards. We can connect a number of data sources to Power BI including data files, online and on-premises services, and Azure.

Power BI Installation

We need the Power BI Desktop application to develop Power BI reports. We can easily get the latest version of Power BI Desktop application from the Microsoft Power BI website. Once downloaded and installed sign up and sign in using your Power BI or Office 365 credentials.

Getting Data from Data Sources to Power BI

Once we complete sign in to Power BI our next step is to get the data from Data Sources including data files, online Services and on-premises Services, Azure, etc. Here we will investigate how we should connect Dynamics 365 Online to Power BI and generate reports using Dynamics 365 data.

Connecting Dynamics 365 to Power BI

Once we select the Dynamics 365 Data source in Power BI by using the Service Root URL, we should be able to connect to our Dynamics 365 instance. To achieve this functionality, follow the steps below.

Dynamics 365 > Settings > Customizations > Developer Resources > Service Root URL

Copy the Service Root URL and add it to Power BI for the organizational account and change or update version 9.0 to 8.2 because 9.0 version is not supported by Power BI yet.

After connecting Dynamics 365 to Power BI successfully, we need to select the Dynamics 365 entities – either System Entities or Custom Entities to generate reports. After selecting the entities, click on the Load button and the entities will load into Power BI.

Selecting Entities

Customizing the Entities

When the Entities are loaded, we can begin to generate reports. For example, if we want to remove some fields from an entity, rename the fields, remove the duplicates, split columns, or directly add a new field to the entity table – we can achieve all these by going to the Edit Queries button.


When all the customizations required are completed, the next step is to create or visualize the report by using different visualization options like Stacked Bar Chart, Stacked Column chart, Pie Chart, Donut Chart, Funnel Chart, etc. After completing visualizations, we can publish that dashboard.

Once we successfully publish our Dashboard, sign in to the online version of Power BI. Our Dashboard is now available to view or share with a single user or the entire organization. We also have the option to surface this dashboard in Dynamics 365.

As you can see, Power BI provides some great features to create dashboard visualizations! You can learn more about business intelligence for Dynamics 365 in this on-demand webinar.

Be sure to subscribe to our blog for more Dynamics 365 info!

Happy Dynamics 365’ing!

Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
powerobjects: Row-Level Security in Power BI with Dynamics 365 Blog bot Dynamics CRM: Blogs 0 16.07.2018 21:13
powerobjects: How to Integrate Power BI with Dynamics 365 for Finance and Operations Blog bot Dynamics CRM: Blogs 0 26.06.2018 01:23
powerobjects: Power BI Data Refresh Performance Blog bot Dynamics CRM: Blogs 0 12.01.2018 03:16
stoneridgesoftware: Configuring Power BI Integration for Dynamics 365 Workspaces Blog bot DAX Blogs 1 07.03.2017 10:04
axsa: Power BI and Dynamics AX: Part 1: Introduction Blog bot DAX Blogs 0 18.02.2015 18:11
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 09:46.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.