D365FO An error occurred during report data sets execution after adding a new dataset

Hi,

A common error in Microsoft Dynamics 365 for Finance and Operations reporting is data set execution problem. It usually occurs after adding another data set to your existing report. The problem is due to caching of previous report state in different programs. One of the following solutions will work for you:

Solution 1-  Restart report service

1.1 Open reporting server configuration

 1.2 Stop and then start the reporting service

Solution 2- Delete the cached RDL file, clear your usage data and build report again

2.1 Open the reporting server configuration

2.2 In the Web Portal URL you can see an URL click on it, it will redirect you to reporting web portal home page.

In case you are unable to click the URL click the 'Apply' button in the footer to enable the URL.

2.3 Delete the report RDL file.

2.4 Clear your usage data from AX -> Settings -> User options -> Usage data -> Reset

2.5 Build and deploy your report again.

You can now successfully run your report :)