Step-by-step: Expanding JSON in Power BI Desktop
Open Power Query
Open Power BI Desktop
Go to Transform data
Select a HubSpot table (e.g. HubSpot Deals)
You’ll see a column called Custom Properties.
Expand the record
Click the expand (⤢) icon on the column header
You’ll see a list of all available custom properties
Select only the fields you actually need for reporting
💡 Tip: You don’t have to expand everything. Keep your model lean.