In this scenario a “couple” of questions arise… As always with MS there are a lot of possibilities but few hints on which of them are the most feasible in a specific situation. We are planning to build a DW to create dataflows in our PBI portal for the most common usage scenarios for different user groups, ie Sales, Production, Financial, Supply etc. Our organization has a yearly revenue around 50M$ and with 120 employees, with no one working 100% with IT-development. Or maybe we should support our dataflows with data direct from the OData interface in our D365 FO cloud-based solution? Pulling with Datafactory or pushing with BYOD? We do not se any use for faster refresh than daily soon.
Which is the best solution and why?
