Excel Power Query, Structured column is greyed out with no option to add " Add Data Type" missing

Question

Hi Experts,&nbsp;Please can you help me, my excel (office 365), I am not able to see the following "Add Data Type" is missing as "Structured Data Column" in the Transform is greyed out. I have tried by selecting the coloumn and multiple columnsThe other things of Interest.&nbsp;1. I also notice that when power query as Com ADD-INs is missing but I am able to get power query transform by selecting the add source.&nbsp; Please can you help me&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

acerNZ&nbsp;Power Query data types are available only for&nbsp;Office 365 subscriber, if you have O365 subscription please&nbsp;get the latest updates&nbsp;to use this feature.
Paul Zheng _ Community Support TeamIf this post helps, please Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Excel Power Query, Structured column is greyed out with no option to add " Add Data Type" missing

2 Replies

Related content

Table structure

Snowflake connector: "We cannot convert the value null to type Text"

ELT JSON / Semi structured

ELT JSON Semi Structured Loop

missing data