APIs & Integrations

NinaH
Member

Engagement ID not found in Power BI through CData ODBC Driver

Hi,

I connected HubSpot to Power BI through CData ODBC Driver for HubSpot 2016 for the first time. I’m able to get data from all the other tables, but when I’m trying to access Engagements I receive the following error message:

“Expression.Error: The column ‘Id’ of the table wasn’t found.
Details:
Id”

Any ideas if this should be issued here for HubSpot or for CData or Microsoft?

Best Regards,
Nina

0 Upvotes
2 Replies 2
SprinkleData
Member

Engagement ID not found in Power BI through CData ODBC Driver

Hi @NinaH 

 

You can use Sprinkle for connecting Hubspot with Power BI. Through Sprinkle, you can easily customise the reports and set KPIs.

 

Regards

Sam

0 Upvotes
3PETE
HubSpot Employee
HubSpot Employee

Engagement ID not found in Power BI through CData ODBC Driver

@Nina,

I would reach out to CData about this as it is their driver and not ours.

0 Upvotes