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

Use the Data Selector to specify Organization data types

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

To convert to a data type from your organization, Excel looks for a match between the cell values and Power BI data in the data type selected from the gallery or pane. If there's a match, you'll see a data type icon in the cell that indicates it converted successfully. If you see a  Question mark icon   instead and the Data Selector pane opens, Excel needs your help to choose the right data type.

Tip: In Excel for the web, you can select the Use the tabs to the right of the Data Selector pane to navigate between panes.  Data Type tab or the  Select the ? on the right to tab between panes in the web.  Help tab on the right side to navigate between the panes.

Try it!

  1. In the Data Selector pane, review the results and select the matching one.

    Not seeing the result you need? Try these:

    • Check that the text is spelled correctly.

    • Make sure each unique term is in its own cell.

    • Modify the term in the search bar, or select Change to view all data types and select a different one.

    Tip: If you still can't find what you're looking for, that data type may not be available to you. See Access Power BI featured tables in Excel or Set featured tables in Power BI Desktop. You may need to contact your IT admin or the owner of the Power BI dataset for help. 

    Screenshot of the Data Selector pane.

  2. Once you select the result you need, the Data Selector will switch to the next result that needs identifying.

  3. When all cell values are linked to a data type, the Data Selector will close and you can now view cards and insert data.

Want more?

Access Power BI featured tables in Excel

Set featured tables in Power BI Desktop

Linked data types FAQ and tips

What linked data types are available in Excel?

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!