Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We are implementing D365FO (currently in Discovery Phase) and I would like to understand how to include a BI Reporting instance. I've noticed that D365 has a lot more reports than our current 2009 instance but i'm looking for a better reproting isntance where I can build non-D365 cubes to link data from other systems. Is there a report server available which can easily connect to D365FO? I've dont a lot of searches but everything references PowerBI which appears to only connect to the D365 system to pull data. I'm looking for a Enterprise Reporting System. Please give me the product name or link to the product?
Well, there are lots of ways to do this. Power BI is an enterprise reporting system, particularly if you go Premium. We do a lot of work with Power BI and Dynamics F&O/CE, it is the go-to platform because of it's tight integration. You can pull data into Power BI but you can also surface reports and visualizations back into D365 very easily.
In general, people do a few different things when working with D365 and Power BI, they tend to go down a few different routes:
Few different reasons to do one or the other but the future is CDS, IMHO.