...read 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…
Hi @OleksandrM ,
According to your question. You can try the following solutions:
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.
If it still does not solve your problem, please inform me in time. Looking forward to your reply.
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.
@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?
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.
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.
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
"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
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 ?
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.