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

Опции темы Поиск в этой теме Опции просмотра
Старый 09.06.2016, 17:11   #1  
Blog bot is offline
Blog bot
25,497 / 847 (79) +++++++
Регистрация: 28.10.2006
stoneridgesoftware: How to Integrate Power BI with Project Madeira

This post will cover how to integrate your Project Madeira instance directly with Power BI (free version).

Project Madeira is based on Dynamics NAV, so this walkthrough will be similar to our Power BI with Dynamics NAV – Demo Install blog post.  The largest difference with Project Madeira deployments built into Office 365, there is no on-premise option and gateway to consider.  We’ll walk through the necessary Office 365 data authentication to get to connect to your Project Madeira instance.

  • O365 Account with Project Madeira and Power BI (free) accessible – this is normally not an issue unless you are in a O365 demo/tenant environment with limited appsContents
  • Verify User Account and Web Service Authentication Key
  • Verify OData for the Dynamics NAV Service Tier
  • Power BI Get Data – Connect to Project Madeira
Verify User Account and Web Service Authentication Key

1. In Project Madeira, navigate to the “Users” page.  (Either use the Search for “Users” or navigate to Company Settings > Users)
2. Select your User Account and click Edit

3. Verify your User Name (which may be different from your O365 account)
4. Verify your “Web Service Access Key” if the field is blank or you’d like to generate a new one, click “Change Web Service Access Key” in the ribbon.


We’ll be using the User Name and Web Service Access Key in upcoming steps.
Verify the Office 365 Data URL is Accessible

1. You can find the Office 365 Data URL within Project Madeira:
a. Use the Search to find Web Services
b. Copy the OData URL from one of the services and strip off the end, up to the Company() portion.


Syntax:  http://[hosturl]:[ODataPort]/MS/OData/Company(‘[companyname]’)
Example:‘CRONUS US’)/

2When you enter your URL, you will be prompted with a login.
a. Username = Your “User Name” from Project Madeira, which may be different than your O365 account.
b. Password = Your “Web Service Access Key”


NOTE: Most versions of IE will give a message “Cannot display this feed.”

Using another browser such as Chrome will work to display/verify the feed:

Power BI Get Data – Connect to Project Madeira

With your Project Madeira OData service and authentication verified, you are ready to connect Power BI to Project Madeira:
1. Go to (sign-in with O365 credentials)
2. Get Data > Services

3. Search for Project Madeira, click on Project Madeira and click Connect.

4. In the OData Feed URL, enter the URL you tested in the “Verify the OData URL is Accessible” step.

5. After clicking next this will ask for an Authentication Method.  Choose “Basic”, fill in the User name, Password and click Sign In.
a. Username = Your “User Name” from Project Madeira, which may be different than your O365 account.
  b. Password = Your “Web Service Access Key”

Once imported, your Project Madeira dashboard will be accessible on Power BI.


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

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
waldo: Project “Madeira” Public Preview Blog bot NAV: Blogs 0 15.05.2016 18:12
axsa: Power BI and Dynamics AX: Part 1: Introduction Blog bot DAX Blogs 0 18.02.2015 18:11
atinkerersnotebook: Walkthrough & Tutorial Summary Blog bot DAX Blogs 1 09.09.2013 09:11
atinkerersnotebook: Using Power BI to Visualize Customer Saturation Blog bot DAX Blogs 1 07.08.2013 08:11
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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