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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 19.06.2018, 22:11   #1  
Blog bot is offline
Blog bot
Участник
 
24,301 / 817 (76) +++++++
Регистрация: 28.10.2006
powerobjects: June Power BI Desktop Update: Dynamics 365 9.0 OData Endpoint
Источник: https://www.powerobjects.com/2018/06...data-endpoint/
==============


Since the release of Microsoft Dynamics 365 version 9.0, we have needed to continue using the 8.x OData endpoint rather than the 9.0.

For example, we have been using:
https://ORGNAME.api.crm.dynamics.com/api/data/v8.2

Rather than:
https://ORGNAME.api.crm.dynamics.com/api/data/v9.0/

With the June 2018 Power BI desktop update, this is now possible! An additional benefit is it is also much faster. If you have attempted to use the 9.0 endpoint in the last several months, you most likely received a message such as this:



First, you need to ensure you have the latest desktop update. If you have installed the Windows 10 App, you should be good to go. If you are updating manually each month you will need to download the June update.

Confirm your version by clicking: File > Help >About

If your version shows May 2018 or older, navigate to the Power BI desktop download to get the latest version.



After downloading and installing, confirm you now have the June 2018 version:



Next, get your data:



Enter your Web API URL: (replace ORGNAME with your actual organization’s name! J)



Now then – in terms of the error, the Navigator successfully loads your list of entities!



Additionally, the June Updates features list includes OData V4 connector enhancements.

In our testing, we found a nice improvement in refresh time. Our sample data set was not large (six entities and a few thousand records) but enough to measure.

Refresh time:
  • 8.2 Endpoint – 45 secs
  • 9.0 Endpoint – 20 secs
If you have existing reports you can simply edit the query and change to 9.0.

1. Open your *.pbix file

2. Click to ‘Edit Query



3. Click the settings wheel on the ‘Source‘ step of your query(ies) and paste or modify the API URL



4. Close Apply to confirm



Now you should be good to go with the 9.0 OData endpoint!

Power BI is a great tool within Microsoft’s suite of business applications. If you’re interested in learning how Power BI can integrate with other powerful Microsoft apps, join us at the Microsoft Business Applications Summit on July 22-24 in Seattle. Register with code HCL100dc to receive $100 discount.

Happy Dynamics 365’ing and Power BI’ing



Источник: https://www.powerobjects.com/2018/06...data-endpoint/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
powerobjects: Dynamics 365 Spring 2018 Update: Introducing D365 for Marketing Blog bot Dynamics CRM: Blogs 0 06.06.2018 01:32
powerobjects: What is the Learning Path for Dynamics 365? Blog bot Dynamics CRM: Blogs 0 10.04.2018 01:27
atinkerersnotebook: Adding Power BI Dashboards to Dynamics 365 for Sales Blog bot DAX Blogs 0 22.03.2017 23:11
crminthefield: Podcast and Overview: Microsoft Dynamics CRM 2011 Update Rollup 13 Blog bot Dynamics CRM: Blogs 0 27.03.2013 22:12
german_nav_developer: Buildnummern-Übersicht Microsoft Dynamics NAV 2009 Blog bot Dynamics CRM: Blogs 0 04.06.2010 13:21
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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