cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

need to create reports with the data on modeldriven app

Hi ,

need to create reports with the data on modeldriven app using the run report and reports using excel or Power BI. Need to have a date time picker(or select a date range) for the user to sort report by date and category.

3 REPLIES 3
Microsoft
Microsoft

Teresa24486,

 

If you're working with a model-driven app, you may actually have better luck over on our Dynamics forums:
https://community.dynamics.com/f

 

It's a bit confusing but model-driven apps are distinct from canvas apps in how they're designed and how they work from a backend perspective. It may also not be necessary to involve a canvas app at all if you're looking to convert data into a Power BI dashboard sort of experience.

 

This article outlines a possible canvas app approach if you do wish to go down that road:
https://powerapps.microsoft.com/en-us/blog/cdsconnectortopowerbi/

 

Let us know!

 

Patrick

Super User II
Super User II

Hi @Teresa24486 

 

Take a look at this article if you want to use Excel for your reporting with CDS data. Excel templates are really easy to set up and are a great way to get reports done quickly.

 

Power BI takes more work to set up and can require additional licenses but it is very powerful. Here are some details to get started with Power BI and CDS https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-powerbi-connector

 

 

I will check this out.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Users online (4,126)