Related topics
Linked data types
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Linked data types

Convert text to an Organization data type

Not only can you get data on subjects like cities, foods, stocks, geography, and more, but you can also get data types provided by your organization through Power BI. You can view data type cards to get specific info about your converted data and extract that to your workbook. Refresh to keep your data up to date and see Power BI data without ever leaving Excel.

Notes: In order to access and use data types from Power BI, you must meet the below requirements. If you do but still don't see the feature, please contact your IT admin for help.

Try it!

  1. In an Excel workbook, enter specific identifying text into separate cells. For example, in a single column, you might enter the names of employees of your organization.

  2. Select the cells and go to Insert > Table to convert to a table. Check the box for My table has headers if you've added them.

  3. Select the text to convert in the table. Go to Data and in the Data Types group, expand the dropdown and select a data type from your organization. If the Data Selector opens, see Use the Data Selector for help. 

    Tips: There are two places where you can specify a data type from your organization:

    • Data types gallery, under From your organization: You'll find up to ten data types available to you, prioritizing datasets marked as "certified" and "promoted" in Power BI.

    • Select More from your organization or the Organization button in the gallery (available in some versions of Excel): This opens the Data Selector pane and shows all data types available to you from Power BI.

Want more?

Access Power BI featured tables in Excel

Set featured tables in Power BI Desktop

Linked data types FAQ and tips

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!