Organizational Data Types in Excel Now Missing

[IamTDR]

Hello
I've created a 'featured' table in Power BI Desktop and uploaded to the website. 

In Excel, I would be able to highlight my field and use organizational data type to select different attributes on that field. 
As of today, my organizational data type is no longer working.  Its been working for over a year now and today it stopped. 

I checked the PBI report with the featured table and found nothing wrong. 
Any idea why this feature just stopped working?  Was actually demonstrating this feature in Excel just last week and now its gone.

[MatusS]

Today I see again issue with data types in excel. It suddenly disapeared today (yesterday I got update of MS Office 365). 

Organization Data Types are missing only in Excel App version and still working on Excel Online.

[Stefan_Volz]

The functionality stopped in our Organization on 16. June 2025 again. In the desktop version the Organizational Type is showing up, but doesn't retrieve any values. In 365 Web version it is working! I am not aware on any changes in our organizational setup. All users are concerned.

[MatusS]

It's the same in our organization — I believe it already stopped working in the Excel desktop version by the end of May. In the 365 web version, it is still working.
One change I'm aware of is that our Power BI workspaces have been migrated from Premium to Fabric capacities.

What concerns me more is that I’ve seen a couple of articles claiming that Microsoft is going to retire this feature. I'm not sure if it's true, as I haven’t seen anything official on the Microsoft Office website.
https://www.neowin.net/news/a-windows-mac-excel-feature-is-being-removed-as-its-too-expensive-for-mi... 

[IamTDR]

I had to adbandon this feature in my organization.  Otherwise, I would receive tickets from end-users thinking the problem was in me setting it up.

[IamTDR]

I noticed this as well yesterday.  My concern is that this feature may no longer be featured as a PBI Pro License user.

[jennibarnhill]

@everromanr , we are seeing this issue again starting in the last day or 2.  Is it possible the fix that was released in September was reverted?  

[Userp]

Happening in our tenant as well, worked yesterday when I checked. Today no longer working again, 3rd time in a year for us. Outage span has always been anywhere from 2-4 days. Same as Stefan_Volz reported, custom Data types not showing up at all in Excel, and nothing changed on our side.

[IamTDR]

Yes.  I am seeing the same thing in excel now.  The custom organizational data types are missing.  Its frustrating as my end users come to me for help, but I cannot do nothing about this.  End users will simply learn not to rely on this feature.

[Stefan_Volz]

For our setup it disappeared as well, this time the complete Data Type doesn't show up any more in excel.
Last time it was showing but not querying any data.
Nothing was changed, and data had been refreshed this morning and are available in PBI.

[Stefan_Volz]

A day after my message, the custom data type is showing up today. Good to know that my organization is not the only one having this recurring problem. It proves that the problem is not within the organization's setup.

[Userp]

Yes, I have confirmed it is now working again in our tenant. Would be nice for product group team to post in MS service health portal when there is an issue, the root cause, and the resolution. With this being the 3rd time  within a year, each time nothing is ever posted in Services health of the tenant.

[jennibarnhill]

Agreed.  We have spent a lot of time responding to service tickets for something that is completely outside of our control and have nothing to offer except, 'sit and wait'.  

[IamTDR]

Yes, my organizational data types also returned this morning.

[MatusS]

I found that this is issue is now tracked between known issues by microsoft. Known issue - Excel enterprise data types feature experiences issues - Microsoft Fabric | Microsoft ...

[Stefan_Volz]

23 Sep 2024 8:45 CEST

Today the organzational data types work in our environment suddenly again. Unfortunately it is not clear, if anything was done in PBI or if it works because something else changed. 

[IamTDR · Accepted solution]

Agree.  Magically my Organization Data Types began working today as well.  

[Stefan_Volz]

One of my collegues has send me the link that the feature is discontinued and not supported any longer from July 31st, 2025.
https://support.microsoft.com/en-us/office/use-organization-data-types-to-view-and-insert-data-c7686...

Too bad, many colleagues found this direct integration into Excel very useful, I cannot see it to be replaced with PBI or custom Excel AddIn with the current functionality.

[MatusS]

Honestly, this is ridiculous. Microsoft keeps killing off good features for no real reason.  And the “solutions” they suggest — like connecting to Power BI or using custom add-ins — are just not the same. 
Organization data types still work fine in Office 365 web and even in older versions of Excel, lets see for how long.

[Stefan_Volz]

It keeps disappearing and appearing in  excel desktop. The only stable version seem to be on Office 365 WEB version. Really annoying, that there seem to be nobody knowing the reasong for it or to fix it permanently.

[everromanr]

Hello @IamTDR 

I can confirm Microsoft Product Group team in charge of this bug started to release the fix by 09/21 EOD, for that reason we see the feature is working again, thanks for your patience and we apologize all the inconveniences caused.