Forum Discussion
Post PartisanWould you recommend re-modelling MS Dynamics 365 data from OLTP to OLAP for use with Power BI?
Community SupportHi D_PBI
If you want to connect to Dynamic 365, I think you could use Dynamics 365 (online) , then modify it in Edit Queries and create corresponding relationship between tables.
If you want to use modified data and relationship, I think you could load the data in sql server and create cube in SSAS, then you could use SSAS cube directly in PowerBI.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Partisandax - thanks for your response. I am aware of the different options we have to model data within the MS BI world, however my question was more so seeking if others have taken the steps of creating a Mutli-Dimensional model, from the Relational model that Dynamics 365 is, and what benefits or lack of benefits did they find?
Also, I'll be interested to know if they re-modelled it in PQ or went the whole hog and re-modelled it using a separate SQL Server database and SSAS, and then hooked PBI into that.
If anyone would like to share their experiences, and why they did it the way they did, it will be good to hear?
Thanks.