D365/PowerBI: Power BI OData Connection (Part I)

-

Microsoft Power BI is a cloud based data and analytics reporting tool that helps organizations bring together disparate data sets into reporting dashboards.  

D365 Finance and Operations users can also use Power BI:
  • To design visual reports and dashboards from D365 data-sets 
  • To embed these dashboards to D365.
In this blog series, we will see how D365 user can work with Power BI. I am going to divide this topic in four parts.

Part I: Create OData connections to access D365 data to design visuals in Power BI
Part II: Design a visual from D365 dataset
Part III: Configure Power BI to pin dashboards in D365
Part IV: Pin Power BI dashboards to D365

In first part, we will connect the Power BI with D365F&O through OData connections to access dataset so that it can be utilized to design visuals.

Pre-Requisites:

You should have a Power BI  account with your work domain and Power BI desktop app installed.

Steps:

We will start by accessing Power BI desktop.
  • Click Get Data.


  • Select Others > OData Feed > Click Connect.
  • Enter URL of D365 online instance (to which you want to connect Power BI).
  • Add postfix '/data' to the URL.
  • Click OK.


  • When you will connect first time, above window will appear. 
  • Select 'Organizational account' tab on the left panel.
  • Click 'Sign in' to provide your sign in details.
  • On successful sign in, click Connect.



Successful connection will show you D365 data tables on navigator.

Comments

Post a Comment

Popular posts from this blog

D365/Power BI: Pin Power BI Dashboards to D365 Finance & Operations (Part IV)

-
Image
In third part of this blog series we did configurations in D365F&O to setup Power BI dashboards. Now we will see how we can pin visuals from Power BI to D365F&O workspaces. We will pin the same visual in D365 workspace that we created in second part of this blog. If you are following all previous parts exactly, you don't have any pre-requisite at this stage. So let's jump in to it. The mentioned screen shot is showing the same step where we ended our last blog. Go to System Administration  > Setup > Power BI Configurations            (After saving application id and application key) Click on 'Get started' button over blue tile under Power BI label. It will take you to the consent page. Click Accept.  Now you are ready to pin the dashboard, choose whatever workspace you want to pin the dashboard. Under desired workspace you will find Power BI blue tile. Click 'Get started'. It will display 'O...
Read more

D365 Accounts Payable: Settle Vendor Retention for Project based Purchases

-
Image
Settle Vendor Retention In previous blogs, I worked on vendor retention setups and discussed how vendor retention gets generated on invoicing a purchase order. Now, in this blog I will show how vendor retention can be  settled at the end when an organization wants to pay off all retained amount for the purchase order which has been already invoiced completely. Let's start... Navigate to Accounts Payable > Invoices > Pending Vendor Invoices  Click From Purchase Order Following query form will appear Make sure all filter should clear except the Purchase order which must have the Purchase order number specified for which retention has been deducted and fully invoiced so has the status as 'Invoiced'. Click OK A row will appear in the following grid. Enter Invoice number Set Default quantity for  lines = Ordered quantity ( Because the mentioned order is fully invoiced, the system does not show the invoice line with other availab...
Read more

D365/PowerBI: Power BI Configurations Setup in D365F&O (Part III)

-
Image
Its a blog series, i n first part , we learnt how to access D365 F&O data in Power BI through OData feed then in second part , we created a visual from d365F&O dataset and pinned it to Power BI portal. In this part, we will do configurations those are required to pin the visuals and dashboards from Power BI to D365F&O.  Following are the details of environments those I am going to use here: D365 version = 8.1 &  PU = 2.0 Power BI Desktop version = 2.6 (February 2019) There are two major steps of configurations: 1. Register App and Generate Key on the Power BI dev portal 2. Provide above generated Key into D365 Power BI Configurations Let's start.... Register App over Power BI First of all we need to access Power BI dev portal where we will register our app and generate a key. Access below link  and sign in. ( http://dev.powerbi.com/apps ) Click Next > It will take you to the App registration page. Here, you have ...
Read more