Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Im importing Appointments from CRM Online.
Each row is very long, and looks like a row that contains multiple records and tables(see screenshot).
Can anyone explain the exact structure of the Appointments entity, and why its made up of multiple tables, instead of simply relating to the data in other entities?
Im not really sure how to handle this entity
Hi @wilson_smyth,
I think you can take a look at below tutorial:
How to Connect Power BI to Microsoft Dynamics CRM Online
BTW, normally power bi will get all summarized records, you need to split current table to sub queries based on different entities and get particular records fields.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |