View Categories

Can I use the OData URL outside Power BI?

< 1 min read

Technically yes — the endpoint is a standard OData v4 feed protected by HTTP Basic auth, so any OData v4 client (Excel, custom dashboards, ETL tools) can read it. The token semantics are identical: HubSpot username + personal access token as the password.

Microsoft Power BI is the intended and supported use case, however. Behaviour with other clients is not guaranteed: query patterns, pagination, projection, and error handling are all tuned for Power BI’s Mashup engine. If you hit a problem with a non‑Power‑BI client, we can’t commit to fixing it on the connector side — the workaround will usually be to point you back at Power BI Desktop or Power BI Service.