@mbaumbr You might consider the HubSpot Integration for Power BI, which is available in the HubSpot App Marketplace. This Certified App has 1000+ installs and gets 5-star reviews. By using the connector, you will be able to create an automated data refresh schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.
A free trial is available.
Did this post help solve your problem? If so, please mark it as a solution.
John Elmer, CEO Bayard Bradford Advanced CRM Implementation | HubSpot Custom Integration Services | Datawarehouse.io Apps for HubSpot Elite HubSpot Solutions Partner > Follow me on LinkedIn