I am wondering if there is any opportunity to get data out of Hubspot into my BI reports.
Do you know something?
An idea about adding HubSpot data source in Power BI has been submitted in this link, please vote it up.
In addition, you can consider to create ODBC data source by after installing the HubSpot ODBC Driver, then connect to the ODBC data source in Power BI Desktop.
There is no native connector pack. Have you considered using a 3rd party tool like datadirect cloud to accesss your Hubspot data as an OData feed? For example: https://www.progress.com/odata/hubspot . Once you produce OData, accessing OData from Power Bi should be straight forward. Here is a tutorial: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-odata/
Please look here for information on our HubSpot connector for Power BI. We provide a low-cost, purpose-built integration service that includes a data warehouse that is optimized for HubSpot Sales, CRM and HubSpot Marketing data.
There is a FREE HubSpot custom data connector to Power BI available on our public GitHub Page.
Why don't you try and provide feedback?
You can have visualizations like this one through the data from the connector.