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.

[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.  

[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. 

[MatusS]

I have observed that it is working for lines which I had already in the feature table before 19 Sep. Any new lines are not being converted.

[everromanr]

Hello Everyone, 

This is a known issue identified internally by the Product Group team, currently they are working on a solution that may be released by the end of the next week, around sept 27th, please wait after that date to test, if the issue persist, please create a support ticket to investigate further. 

[MatusS]

Having the same issue. Is the solution related to excel update? I am currently on Excel Version 2408 Build 16.0.17928.20114

I noticed it is not working from 17 Sep 2024 about the same time as Microsoft 365 update on my pc.

[jennibarnhill]

Hi @Ritaf1983 , we are also experiencing this issue.  The first user reported it on Monday September 16th.  If you connect to the Power BI dataset in excel, you can insert a pivot table and see the data, however, using the exact same result will not be recognized when choosing the data type.   I also tried excel for the web to see if it would work there but the result was the same.   

[Stefan_Volz]

Having the same issue, just wanted to add, that the funtionality dissappeared 12th Sep 2024, on 13th it was suddenly working and after the weekend 14/15 Sep it stopped again. It is not the first time that we have problems, but last time the Organziational Data type disappeared completely in the Excel Ribbon. Now it still exists but there is no data pull or info querying to PBI any longer. The Excel "Data Selector" justs says "No results found for .....".

To test if it is a problem with the data I have set up a new featured table with one row and 4 columns , text only. It also failed 

It is frustrating, that this feature is not reliable.

It lacks also some control, there is no error messaging. The usage to see the acceptance or to identify the impaced users cannot be seen.

[Userp]

Happening in our tenant as well, 1st noticed by our users yesterday.

[cmm504]

This is also an issue for my team.