Linked data types

Convert text to an Organization data type

Convert text to an Organization data type

Your browser does not support video.

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?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×