{"id":36494,"date":"2021-03-14T20:21:25","date_gmt":"2021-03-14T14:51:25","guid":{"rendered":"https:\/\/techmasala.addastudents.com\/dev\/?p=36494"},"modified":"2021-03-15T11:12:36","modified_gmt":"2021-03-15T05:42:36","slug":"connect-dynamic-365-finance-and-operation-to-power-bi","status":"publish","type":"post","link":"https:\/\/techmasala.addastudents.com\/dev\/connect-dynamic-365-finance-and-operation-to-power-bi\/","title":{"rendered":"Connect Dynamic 365 Finance and operation to Power Bi"},"content":{"rendered":"\n

First create an application in Azure Active Directory. For creating application in azure directory you will need to get into the section of App Registration and create your new app.<\/p>\n\n\n\n

Note: in the web api url section at the end of the dynamics url you need to add “\/oauth”.
for eg; <Dynamics Url> \/oauth<\/span><\/strong><\/p>\n\n\n\n

Because while connecting to the Power bi the redirect url will use oauth authentication else there will be error\/issue that the redirect url is not validated.<\/span><\/strong><\/p>\n\n\n\n

Move to the App Registration section as mentioned below.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

One is already created in the above. For creating new click on New registration and specify the below<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

 specify the name , the app created will be for single or multi tenant.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Choose web and specify the url.<\/p>\n\n\n\n

Now copy this application id for bi connection<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Now assign this app permission for power bi service<\/p>\n\n\n\n

And after this go to the manifest and allow for public client by assigning it true , by default it is false.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now after this create key for this application by which we will access this application. For creating this go to the Certification and secrets section of the AAD, below is the screenshot for the same.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Note: This key is visible one time, you can save this for further uses. This key is valid for a particular time period, you can specify the time while creating this key.<\/span><\/strong>
Click on New client secret, as mentioned below .<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Enter description and time frame and save for key for further uses.<\/p>\n\n\n\n

 
2.  Now move to your dynamic 365 finance and operation environment System administration -> Setup -> Power Bi Configuration , as shown below :
 <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

You  can choose edit to fill in the details.
 <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now specify your application id in the application id section and specify the one time secret value in the application key section, and enable Powerbi.integration, As highlighted above and save this.
Now the changes saved will be affected after having refresh so you can refresh your browser using ctrl+shit+r and then you can see the bi changes.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now you can see the visible changes, click on get started and authenticate to bi.
 <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you have not specified oauth at the end then you will face below error .<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Else, you will be redirected to the below .<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now refresh your bi configuration page and you will be able to access all the report created in bi .<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click on highlighted..<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

As I have created two records, I am able to access the two and I can choose to add to D365 finance and operation.
 <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You see your added reports , as above.<\/p>\n\n\n\n

By clicking on the one you can see your created report.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

For getting started to power bi and designing report you can refer to the below link:<\/p>\n\n\n\n

\n
Design Sales Report in Power BI<\/a><\/blockquote>