Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

Strange mystery - Featured table in Excel don't even appear

Hello, forum, checked all Microsoft documentation.

I'm the Admin and the owner of Dataset.

Myself, and all colleagues who uses report, have Power BI pro, Office 365 E5, Excel x64 2008 version.

I created Featured Table in Power BI, and the most of my colleagues see it! Can work with it, no issues.

The mystery is - I do not see Featrued Tables, in my Excel I don't even see Organization (screenshot). Most of colleagues see it, but me and some others don’t. We all have same office profile, same software installed, same versions.

Our IT is desperately trying but seems there is no ideas how to solve, no documentation on it. All docs from Microsoft explored, cross checked.

Any ideas, maybe…





Community Support
Community Support

Hi @OleksandrM ,

According to your question. You can try the following solutions:
workaround1:Restart Excel
Sometimes simply restarting Excel 365 or Windows is enough. Closing and restarting Excel or Windows completely is enough to force Excel to try connecting again.

workaround2:Repair Office 365
A failure of Stock and Geo data types can be persistent. Updating Office and Windows doesn’t fix the problem.
Try repairing Office 365. That often does something to your Office setup which makes Stock and Geography data types reappear. In Windows go to Control Panel ->Programs & Features -> Office 365 -> Change then choose Online Repair. Mac users don’t have a similar Repair option. Instead you uninstall Office and reinstall it.

Here is an official document about the featured table can be used as a reference: 

If it still does not solve your problem, please inform me in time. Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-henryk-mstf can you please check the original post and the screenshot there. I don’t have issues with Geo and Stocks, I have issue with Organization type of data and featured table by Powe BI. And I also reinstalled office, and restarted since the original post several times. 100% of recommendations by Microsoft didn’t help, this is why I post it here. 

Frequent Visitor

@SpiroswayGR  connected with organizational account, and I see georgaphy and stocks (please check the first post), so thow links you posted is not relevant, but hank you. All basic sanity including office repair and then re-installation are completed.


As i see, are admin so are you powerbi admin too?

Administrative control

Power BI admins can control who in the organization can use featured tables in the Excel Data Types Gallery. See Allow connections to featured tables in the Admin portal article for details.



Otherwise i suggest to create a ticket and maybe you will get your solution faster.



Frequent Visitor

Another update: yes, reinstalled office, yes, logged in with same organizaional accoutn.

@SpiroswayGR thank you for the links, but they rather solving the issue when data types are missing. they are not, Geography and Stocks are there, missing only organizational type. and again, number of same users, same profile, same subscriptions, and same versions of installed Office/Excel.

Frequent Visitor

@priquelme and @SpiroswayGR 

Yes, office reinstalled, account check, same tenant, same settings. But the most important: it works with one users and don't work with others. I publish the post as maybe someone already experienced the issue and knows "how to". Settings, versions, tenant settings - all it make sense to check if it would not work at all, but it works.

@OleksandrM I think i found something

1st :

"Wow, thank a lot!  This solved my problem too, after much searching and frustration...  When I logged into my Microsoft account from within Excel (File / Account) the stock and geography data types showed up.  When I log out, however, these data types disappear again.  So it appears the use of these data types requires being logged into the Microsoft account.


Microsoft -- please add this to the instructions on the use of these data types!  Users must be logged into their Microsoft accounts to enable these new features."


2nd : If above solution not work , please check below

Frequent Visitor

Are you connected with your organisation user account ?

Resolver III
Resolver III


Get the same excel file from another pc that working and open it with your excel to see if working or not.


Also did you try to reinstall office too ?

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.