How to Import Records from Excel Using X++ Code in D365FO

  How to Import Records from Excel Using X++ Code in D365FO   Include the below namespace in X++ code it will requires to import Excel. Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange;   In addition to the basic reference, include (Directory and DirectoryUpgrade Packages) X++ Code: Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange; class ReadExcel {   public static void main(Args _args)    {     Int id;     Str Name;      System.IO.Stream stream;       ExcelSpreadsheetName sheet;              FileUploadBuild fileUpload,fileUploadBuild;       DialogGroup dialogUploadGroup;       FormBuildControl formBuildControl;   ...

Power BI Dashboard Visuals Within Dynamics 365 FO Workspaces


Step-by-Step Guide

Within a Dynamics 365 for Finance and Operations workspace, scroll to the right of the workspace until you see the “Power BI” section.
Click “Get started”.

Authorize Power BI window will open.
Click here to provide authorization to Power BI.
Ensure that you have logged on to the Power BI service www.powerbi.com
Click “Accept” to finish the integration:
Click “Close” at the bottom of the “Success!” screen:
Back in your workspace, click “Get started” in the “Power BI” section:
Now the “Open tile catalog” window will pop up, showing all the dashboards you have access to in your Power BI service.
Select the visuals that you want to pin in your Dynamics 365 for Finance and Operations workspace. The checkbox is in the top right corner of the visual.
Click OK.
Unchecking the visuals will remove them from your Dynamics 365 for Finance and Operations workspace (see below to add/remove visuals).

Prerequisites

Main steps we need to go through in order to configure Power BI for Dynamics 365. 
The steps are:
·         Create an Azure AD Application
·         Configure Dynamics 365 for operations for Power BI
·         Configure Power BI
·         Configure your workspace

Comments

Popular posts from this blog

D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++

Passing Args from one Form to another Form in dynamics AX

CREATE AND POSTING PURCHASE ORDER THROUGH X++ DYNAMICS AX