Forum Discussion
D365FO and BI Server
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?
1 Reply
- Greg_DecklerCommunity Champion
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:
- Entity Store
- BYOD
- Common Data Service
- Dataflows
Few different reasons to do one or the other but the future is CDS, IMHO.