Pull data from Hubspot into PBI via API

When working with HubSpot data in Power BI, API limits can slow things down if you request too much data at once or refresh too frequently. HubSpot’s API often returns nested JSON, so expect to spend some time flattening and transforming the data before it’s ready for reports. Splitting queries into smaller parts or filtering data helps keep things manageable. If you want to skip coding, tools like Skyvia can handle syncing HubSpot data to a database automatically, making reporting easier and more stable.