Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
1 year ago
Solved

Click Dimension Connectivity

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

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.