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

Опции темы Поиск в этой теме Опции просмотра
Старый 02.03.2017, 17:11   #1  
Blog bot is offline
Blog bot
25,497 / 847 (79) +++++++
Регистрация: 28.10.2006
dyn365finsupport: How To: Deploy the Dynamics 365 for Financials Power BI content pack.

Here is a quick walk-through on deploying the Dynamics 365 for Financials Power BI content pack.  This walk through assumes that you are already able to log into your own Power BI environment.

First you will need to make sure you have your user setup with a ‘Web Service Access Key’ in Dynamics 365 for Financials.
  1. Log into your Dynamics 365 for Financials site.
  2. Search for the ‘Users’ window and open it.
  3. Open the ‘User Card’ of the user who you would like to have access to the Power BI reports.
  4. Check to see if they already have a ‘Web Service Access Key’ – If they do not, use the ‘Change Web Service Key’ option at the top of the window.
  5. Set an expiration date or set it to never expire and create your key.
  6. The ‘User Name’ and ‘Web Service Access Key’ on this ‘User Card’ window will be your User Name and Password that you use in Power BI later.  Keep this window open or save each for use in the following steps below.
You can now move on to Power BI.
  1. Log into your Microsoft Power BI site.
  2. Click on the ‘Get Data’ arrow in the lower left hand corner of the screen
  3. Click on the ‘Get’ button under Services
  4. Type ‘365’ into the search bar in the upper right hand corner and find the ‘Dynamics 365 for Financials – Sales’ content pack and click ‘Get’
  5. The first thing it will ask for is the ‘Dynamics 365 for Financials Web Service URL’.  You can find this URL in the ‘Web Services’ window in 365 Financials if you search for it.
    In the ‘Web Services’ window there is an ‘OData V4 URL’ column that you can copy the URL out of.  Parse it down so that it ends at the company.  It should look like this when you paste it into Power BI.’)

    NOTE – will need to be your tenant name (you can just pull this out of the URL you use to access 365 Financials).  Your company name at the end will also probably be different unless you’re just setting this up for testing and using CRONUS US company.
  6. Once you populate the URL into Power BI and click next it will attempt to automatically authenticate you.  This will fail and can take several minutes in some instances.  Just wait for it to fail.  Once it has failed it will present you with a Drop-down to select an ‘Authentication Method’.  Change the ‘Authentication Method’ to ‘Basic’.
  7. You can now enter your ‘User name’ and ‘Password’.  You will use the ‘User name’ and ‘Web Service Access Key’ from the ‘User Card’ window in Dynamics 365 Financials respectively.  You do not use an Email here as the username.
  8. Click ‘Sign In’ and the content pack should load into your Power BI environment and fill up with information.  This can take several minutes.
If you do not have any data that is relevant to the Content Pack reports you may see an error.  Loading this content pack will give you a Dataset, Report and Dashboard.

I hope this helps you get started in Power BI with the content pack.  If you have any questions swing over to the forums and make a post –

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

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
Microsoft CRM: Power BI with Microsoft Dynamics 365 Blog bot Dynamics CRM: Blogs 0 08.02.2017 20:11
dynaxtips: Upcoming Power BI Content packs and reports Blog bot DAX Blogs 0 09.01.2017 10:11
axsa: Power BI and Dynamics AX: Part 1: Introduction Blog bot DAX Blogs 0 18.02.2015 18:11
atinkerersnotebook: Using Power BI to Visualize Customer Saturation Blog bot DAX Blogs 1 07.08.2013 08:11
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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