HubSpot free CRM solution, with detailed reports on sales activity, productivity, and individual performance, you can track your team toward quota and all the data you need to coach your team to success.
When it comes to combining different sources, not only CRM, we often use third-party Connectors. Here is one of them by Windsor.ai. It also has an inbuilt feature preventing you from crashing the report by failing to connect your data or obtaining the propper API Key for data access.
HubSpot Overview Report template visualizes your HubSpot Contacts in Power BI in a few clicks. You'll have access to all HubSpot data, and the whole process should not take you more than 5 minutes.