Create a new project in Visual Studio 2019 with Report Server Project Template
Add Data source in the Project file using Microsoft Dynamics 365 Fetch with the Connection String
If the Microsoft Dynamics 365 Fetch is not available in the Type we need to Install below two Extensions
Install Dynamics 365 Report Authoring Extension - 2019
Dynamics 365, version 9.0 Report Authoring Extension (with SQL Server Data Tools support) - 2019
Create a new File in the Reports folder selecting the option as Report
Now Create a Shared Datasets with the Name Dataset1 and we need to select the Data Source and the Type should be text and now we need to add FetchXml in the Query and click on the Query Designer to check whether the given FetchXml working or not. After Clicking the Query Designer a pop-up will shown to confirm the data source user or not give your mailId and password.
After clicking the Query Designer the below Pop-up will be shown need to give username and password
In this step we can Create a report as we required with these options
Here is the sample report with the Fields name and values added as expressions.
Add Report1.rdl file in the power apps and the record type should be existing file and we need to choose the categories and select the Related record Type is (entity) and we can check the report by using Run Report Option.
Now create a Solution for Ribbon Button and add existing entity with no components .
Create SSRS Report for Dynamics365 PowerApps Record with a Custom Ribbon Button