cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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

Hi Experts,

 

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 columns

The other things of Interest. 

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.  Please can you help me 2021-01-19_14h16_36.png

 

 

 

 

 

 

 

 

 

 

 

Thanks 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Community Support
Community Support

@acerNZ 
Power Query data types are available only for Office 365 subscriber, if you have O365 subscription please get the latest updates to use this feature.


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

@acerNZ 
Power Query data types are available only for Office 365 subscriber, if you have O365 subscription please get the latest updates to use this feature.


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

@V-pazhen-msft 

Thanks Paul, Yes I am on Office 365 but updates are controlled by organization, I have no control. So I cannot do much. 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors