*If you are building model-driven Power Apps and NOT using Dynamics 365, don’t get hung up on the name, you can create SSRS reports pointing to a Dataverse that you can launch from non-Dynamics 365 model-driven Power Apps. Dynamics 365, version 9.0 Report Authoring Extension*.Microsoft Reporting Services Projects Visual Studio Extension.Visual Studio 2019 (The free community edition will work perfectly well).SSRS (SQL Server Reporting Services) is a viable option as it is included as a feature of Dataverse and provides a lot of flexibility and options in creating reports. Power BI (especially paginated reports) is an option but requires some very expensive licensing and also requires additional integration steps into model-driven apps. Microsoft Word templates can provide some of this functionality, but has issues with pulling multiple tables, sorting and layout. The ability to generate formatted, printable documents with information from Dataverse is still a very important business requirement. Walker’s SSRS REPORTS FOR CDS & D365 online course. WANT SSRS REPORTS TRAINING? Check out Megan V. Microsoft has finally updated the tools that can run on the latest versions of Visual Studio (2019) so here is an all-new, all-fresh version of how to install the tools you need to create SQL Server Reporting Services Reports that will run on model-driven Power Apps and Dynamics 365 (Customer Engagement Apps).Īs a bonus, at the end of this post we will create a simple report and upload it to a model-driven Power App. The post was likely popular because there were different components in the setup process and Microsoft never did a great job explaining all the pieces and steps.Īnother challenge installing the tools was that it required SQL Server Data Tools 2015, even after there were newer versions, and many started the process assuming the latest version would work (it didn’t). Despite all the cool stuff you can do with the Power Platform, one of my most popular blog posts is Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365.

Microsoft ssrs report builder download