January Problem Solver of the MonthCongratulations to Sourav Dam for be selected in our monthly random drawing, Dynamics Community Problem Solver Sweepstakes.
Read aboug Sourav | Learn how to enter
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I'm trying to see what all entities do I have in my Dynamics 365 account? what is the structure of each one of them and how they all are related to each other? Also, what is the data in each entity table? I tried two methods1) Installed Power BI desktop app and imported data to see it. 2) Installed Visual Studio and SSIS packages along with KingswaySoft Connection Manager. In the first method, I could see the tables and content but not relationships.In the second method, I could see the table and structure but not the content and relationship with other tables. It would a great help if somebody could point out the right way of viewing the data in dynamics 365.
You can use ERD plugin from Xrmtoolbox www.xrmtoolbox.com/.../JourneyIntoCRM.XrmToolbox.ERDPlugin
I don't think that you will find a single way to get the content as well as definition. Insted of going for external tool, I would suggest to check the customizations as this will give you list of all entity, relationship etc. You can also do an advance find query to do a quick check on the data stored in the entity.
Hope this helps.
Not possible with single tool.
I normally GoTo -->Settings-->Customizations and explore each entity and look for 1:N,N:1 and N:N relationship and prepare document for future reference.
To view data you can use advanced find.
Another way is mahendra suggesting to use ERD plugin www.xrmtoolbox.com/.../JourneyIntoCRM.XrmToolbox.ERDPlugin
After all it will give you ER diagram of all Dynamics 365 entities but you have to use advanced find to view data. Thanks
Kindly mark suggested answer verified if it resolved your issue and close this thread.
Business Applications communities