Power BI is one of the biggest and most popular BI tools today and it is a central part of many companies’ business intelligence toolbox. Therefore, it is essential to integrate your ERP solution with your Power BI. This post will explore the method for retrieving D365FO data from Azure Data Lake.

We can generate from D365 Finance some standard reports really useful, printed in Excel with the required format for using during the month closing and even generate it for the internal audits.

There are two key reports in General Ledger that I recommend you configure and use it for your month closing or daily validations, let's see the details about the required setup and how to generate it.