easy way to create reports in Dynamics 365 online is through Report Wizard. Reports created through Report Wizard are FetchXML based.
Open Power Apps Maker Portal (https://make.powerapps.com/), click Solutions. Select an unmanaged solution and click New -> Report.
Select the Report Type as Report Wizard Report and click Report Wizard button.
Select Start a new report and click Next.
Enter the report name, description, select the primary record type and related record type (optional). Click Next.
Apply required filters for both entities. Click Next.
Select one or more fields on grouping. Then select the required columns and set properties as per your requirements. Click Next.
Define the format of the Report as per your requirements. Click Next.
Review the report summary and click Next.
The Report is successfully created. Click Finish.
Click Save and Close to close the Report.
To run the Report, open Accounts, click Run Report, and select the newly created Report (in this case, it’s My Accounts Report).
