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]

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.

[rflanagan]

I am having the same issue.  I wonder if its a bug.  They have been working for years and all of a sudden they all show with the question mark icon.

[IamTDR]

Thanks for the reply.  Was hoping it was not limited to my experiencing.  Lets me know it isn't related on my end.  Hopefully Microsoft resolves this soon.

[Ritaf1983]

Hi @IamTDR 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[IamTDR]

Nothing really to share.  I had a very simple table setup exclusively for a Organizational Datatype that I've been using for over a year.  Now without warning, it no longer works.  Other data types are not working either.
Wondering if this is a Microsoft issue and will just magically work again in a day or two.