check before: 2025-07-31
Product:
Microsoft 365 Apps, Microsoft Search, Power BI
Platform:
Android, iOS, Mac, Online, Web, World tenant
Status:
Change type:
User impact, Retirement
Links:
Details:
Summary:
Microsoft Excel will retire the Organization data types feature on July 31, 2025, due to low usage and high costs. Users are advised to use the "Get Data > From Power BI" import feature or an add-in for custom entities. This change affects all Excel platforms, but existing data will be preserved without refresh capability. Bing data types remain supported.
Details:
We will retire Organization data types in Microsoft Excel effective July 31, 2025. This feature has low usage and high ongoing sustaining costs.
Instead, we recommend customers switch to the Get Data > From Power BI import feature on the Data ribbon in Excel to import data from Power BI or an add-in to create custom rich entities for the organization.
This retirement affects Excel for Windows desktop, Excel for Mac desktop, Excel for the web, and Excel for iOS/Android.
After this retirement, we will remove the Organization option from the Data Types gallery on the Data tab on the ribbon, and users will not be able to convert values to new organization types. Existing data in workbooks that used the Organization data type will be preserved but will no longer refresh. This change will have no impact on Bing data types, which we will continue to support.
Learn more
Use Organization data types to view and insert data - Microsoft Support
Connect Excel to Power BI semantic models - Power BI | Microsoft Learn
Overview of data types in Excel add-ins - Office Add-ins | Microsoft Learn
Change Category:
XXXXXXX ... free basic plan only
Scope:
XXXXXXX ... free basic plan only
Release Phase:
Created:
2025-05-13
updated:
2025-05-13
Task Type
XXXXXXX ... free basic plan only
Docu to Check
XXXXXXX ... free basic plan only
MS Preperations
XXXXXXX ... free basic plan only
MS Urgency
XXXXXXX ... free basic plan only
MS workload name
XXXXXXX ... free basic plan only
summary for non-techies**
Microsoft Excel will retire the Organization data types feature on July 31, 2025, due to low usage and high maintenance costs, and suggests using "Get Data > From Power BI" or an add-in as alternatives for managing custom data.
Direct effects for Operations**
Retirement of Organization Data Types
Users will lose the ability to use Organization data types in Excel, impacting their ability to access and refresh organizational data directly within Excel.
- roles: Data Analysts, Business Users
- references: https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview, https://support.microsoft.com/office/use-organization-data-types-to-view-and-insert-data-c7686113-f906-40c8-b9eb-d97c41702469
" target="_blank" rel="nofollow noopener noreferrer">https://support.microsoft.com/office/use-organization-data-types-to-view-and-insert-data-c7686113-f906-40c8-b9eb-d97c41702469
Data Refresh Limitations
Existing data will be preserved but will not refresh, leading to potential data inaccuracies and outdated information in reports.
- roles: Data Analysts, Report Creators
- references: https://learn.microsoft.com/power-bi/collaborate-share/service-connect-power-bi-datasets-excel, https://support.microsoft.com/office/use-organization-data-types-to-view-and-insert-data-c7686113-f906-40c8-b9eb-d97c41702469
" target="_blank" rel="nofollow noopener noreferrer">https://support.microsoft.com/office/use-organization-data-types-to-view-and-insert-data-c7686113-f906-40c8-b9eb-d97c41702469
Increased Dependency on Power BI
Users will need to adapt to using Power BI for data imports, which may require additional training and adjustment time.
- roles: Data Analysts, IT Support
- references: https://learn.microsoft.com/power-bi/collaborate-share/service-connect-power-bi-datasets-excel, https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview
User Experience Disruption
The removal of a familiar feature may disrupt workflows and lead to frustration among users who relied on Organization data types.
- roles: Business Users, Data Analysts
- references: https://support.microsoft.com/office/use-organization-data-types-to-view-and-insert-data-c7686113-f906-40c8-b9eb-d97c41702469, https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview
Potential Data Management Challenges
Users may face challenges in managing and integrating data from different sources without the Organization data types feature.
- roles: Data Analysts, Business Users
- references: https://learn.microsoft.com/power-bi/collaborate-share/service-connect-power-bi-datasets-excel, https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview
Configutation Options**
XXXXXXX ... paid membership only
Potentional Risks**
XXXXXXX ... paid membership only
IT Security**
XXXXXXX ... paid membership only
explanation for non-techies**
XXXXXXX ... free basic plan only
** AI generated content. This information must be reviewed before use.
a free basic plan is required to see more details. Sign up here
A cloudsocut.one plan is required to see all the changed details. If you are already a customer, choose login.
If you are new to cloudscout.one please choose a plan.
Last updated 1 month ago
