Dynamics CRM online - ActivityPartySet

[bpalermo]

Hi,

Anybody else tried working with the activityParty entity in powerbi from CRMonline?   Any tips?  I cannot seem to get any type of query folding to happen on it so it takes hours to download what is a couple hundred thousand records.

Have tried accessing and joining from the contact entity and also the campaign response entity, but to no avail.  All other entities are 10 x quicker with similar amounts of data.

Thanks

BPalermo

[v-yuezhe-msft]

Hi @bpalermo,

I am not familiar with the ActivityParty entity of Dynamics CRM online. Could you please describe more details about which step you encounter the issue and post relevant screenshots?

In addition, there is a blog about how to work with Dynamics CRM online entities in Excel for your reference, in Power BI Desktop, you will have similar sorts of options that you have in Excel to work with entities.

Thanks,
Lydia Zhang