PowerBI - column not in rowset

Developer Support APIs & Integrations
1

Hi For the past week a link to PowerBI that has worked for months is failing due to:

The ‘hs_all_assigned_business_unit_ids’ column does not exist in the rowset.

would the field name have changed on HS side?

No changes have been made to the PowerBI or in the clients HS that would seem to cause this.

Thanks for any input

2

Hi, @AMelbourne :waving_hand: Thanks for reaching out. To your question, the label, and internal value for this property have not changed or updated. Two quick ways to verify this are:

  • Settings > Properties > Contacts (for example) and search for Business Units

CleanShot 2023-05-02 at 10.15.42.png
CleanShot 2023-05-02 at 10.15.42.png949×650 99.3 KB

  • The Properties API (using the Contacts object as an example)

    curl --request GET \
 --url 'https://api.hubapi.com/crm/v3/properties/0-1/hs_all_assigned_business_unit_ids?archived=false' \
 --header 'authorization: Bearer YOUR_ACCESS_TOKEN'​

    HTTP 200

{
 "updatedAt": "2023-02-23T19:08:00.695Z",
 "createdAt": "2021-06-22T17:52:16.232Z",
 "name": "hs_all_assigned_business_unit_ids",
 "label": "Business units",
 "type": "enumeration",
 "fieldType": "checkbox",
 "description": "The business units this record is assigned to.",
 "groupName": "contactinformation",
 "options": [],
 "displayOrder": -1,
 "calculated": false,
 "externalOptions": true,
 "hasUniqueValue": false,
 "hidden": false,
 "hubspotDefined": true,
 "modificationMetadata": {
 "archivable": true,
 "readOnlyDefinition": true,
 "readOnlyValue": false
 },
 "formField": false
}

Question:

  • Did anything change with your client’s subscription? I ask because you used the Professional tag, but this is a feature available to Enterprise subscriptions.

If not, I’d suggest they file a ticket with support and specifically inquire about having challenges with this property. Support cannot help with 3rd party tools, but they can provide insight into a specific portal, and it’s available properties in a way the community, and I, cannot.

Best,

Jaycee

3

Hi,

I was running into the same issue. After doing some research and trouble shooting, what ended up working for me is adding a ‘hs_all_assigned_business_unit_ids’ custom column with null values to the affected tables in my data set.

Something is not allowing that column to flow through to Power BI anymore (whether it was actually removed, there’s an issue with the API, the Hubspot connector app, etc) and Power BI keeps looking for it (whether it’s because you have a remove column: ‘hs_all_assigned_business_unit_ids’ somewhere in your code OR Power BI service’s cache still thinks it’s there, etc).

4

Hi Yes When I asked the technical department they say they haven’t made changes but they have introduced a new Business Units API this past March which now exposes business unit data, which in turn might have required them to add the business_units_view.read permission to the oauth scope.

Their OAUTH documentation makes no mention of the business_units_view.read permission, so the permission maybe new and might be required for the business units api, and potentially for other apis that expose business unit related fields but if you don’t have business units set up you cannot select the scope to enable it.
In the end I just excluded that field from the api request by filtering it out from the table of properties collected from Hubspot, using the applied step below, before making the data request using all the other properties.

= Table.SelectRows(#“Your table name”, each [name] <> “hs_all_assigned_business_unit_ids”)