How to get label value of OptionSet Attribute of accountcategorycode for Dynamics entity with PQ

[PbiCeo]

Hello everyone,

I tried to get label value of OptionSet Attribute of accountcategorycode for Dynamics entity with PQ,

but I couldn't.

The following is Dynamics web API which works on the browser and I want to do the same thing using PQ.

How should I write it?

GET[OrganizationURI]/api/data/v9.1/EntityDefinitions(LogicalName='account')/Attributes(LogicalName='accountcategorycode')/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?
$select=LogicalName&$expand=OptionSet($select=Options),GlobalOptionSet($select=Options)

It works as PQ, but it is slightly different from what I want to get and doesn't work for ODBC.
GET[OrganizationURI]/api/data/v9.0/EntityDefinitions(LogicalName='account')?$select=LogicalName&$expand=Attributes($select=LogicalName;$filter=AttributeType eq Microsoft.Dynamics.CRM.AttributeTypeCode'Picklist')

Does anyone give me advice?
Many thanks in advance,
Vladi

[lbendlin]

show your Web.Contents() Power Query code.

[PbiCeo]

Actually I tried it with Excel using Dynamics connector.

Is Power BI PQ different from Excel PQ?