Click Dimension Connectivity

[lherbert501]

Hi,

I have looked around but can't see anything.

Could somebody please help me to connect Click Dimensions to Power BI?

I can't see it in Get Data. Would it be an API or ODate connection or is there a better way?

Thanks

Liam

[v-pbandela-msft · Accepted solution]

Hi @lherbert501,

Thank you for reaching out in Microsoft Community Forum.

ClickDimensions doesn't have a native connector in Power BI, but you can connect to its data using the following methods:

1.If you're using ClickDimensions with Dynamics 365, the data is stored in D365 entities.
You can connect via the OData endpoint:
->In Power BI, go to Get Data > OData Feed
->Use your Dynamics 365 OData URL (e.g., https://yourorg.crm.dynamics.com/api/data/v9.1/)
->Look for ClickDimensions entities like cdi_formsubmission, cdi_emailevent.

2.you can export data to Excel or sync it to SQL, then connect Power BI to those sources.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[lherbert501]

Thankyou @v-pbandela-msft  for your reply