topic Re: D365FO and BI Server in Report Server

D365FO and BI Server

Anonymous — Sat, 28 Dec 2019 16:50:54 GMT

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?

Re: D365FO and BI Server

Greg_Deckler — Sun, 29 Dec 2019 16:37:15 GMT

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.