How to see all the underlying tables in Microsoft Dynamics 365

Resolved · Low Priority · Version 2016

Tue 13 Aug 2019, 16:32 Delegate Hannah said...

Hannah has attended:
Power BI Modelling, Visualisation and Publishing course

How to see all the underlying tables in Microsoft Dynamics 365

I work with an external consultant firm and they are implementing Dynamics 365, how can I see the relationships between tables in BI?

Tue 13 Aug 2019, 19:29 Trainer Jens said...

RE: How to see all the underlying tables in Microsoft Dynamics 3

Hi Hannah,

Thank you for the forum question.

I have found some useful links which clarify how Power Bi can be connected to Dynamics 365 which are a relational Database build by related tables.

How to see the relationships Dynamics 365
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/basics/hierarchical-relationship

How to connect Power Bi to Dynamics 365
https://us.hitachi-solutions.com/knowledge-center/power-bi-dynamics-365-finance-operations-part-3-use-odata-connectivity-create-power-bi-reports/

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/use-power-bi

Understanding relationships in Dynamics 365
https://www.youtube.com/watch?v=sYRBjg_LJbk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 20 Aug 2019: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Microsoft office training

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Full Menu Display (Office 2003-2000)

One of the developments in Microsoft Office is that the Menu system has been optimized. This means that only recently used functions are displayed initially when you SINGLE CLICK on the menu.
There are many ways of getting around this:
1. DOUBLE CLICK on the menu bar, it will automatically expand
2. click on the DOUBLE ARROW you see on the bottom of the menu.
3. Wait for the menu to expand

If you always want to have the menus expanded:
4. On the menu bar, click TOOLS, then CUSTOMISE. Select OPTIONS, then uncheck the

View all Microsoft Office hints and tips