Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

A Binary-typed column can store a large data size, such as an image. A large data size is known as a binary large object (BLOB). You can load blobs of data, such as an image, into the Data Model from data sources that support this data type such as SQL Server.

Tip    You can also use Power Query M Language functions, such as File.Contents and Web.Contents, to load blob data into a Data Model or even a query.

Example

For example, you want to load an image from a SQL Server database into the Data Model. Your query imports a list of product names and images.

Example data with binary columns

Procedure

  1. Load your data to the Data Model. For more information, see Create a Data Model in Excel.

  2. Select Power Pivot > Manage.

  3. Select File Switch to Advanced Mode.

  4. Select Advanced > Table Properties.

  5. To enable a column containing binary data, in the Table Properties grid, select a Binary Data column, such as ThumbNailPhoto.

    Example of a binary column of a thumbnail image

  6. Select File Save.

  7. Select Advanced > Table Behavior.

  8. In the Table Behavior dialog box, select a column from the Row Identifier drop-down list, such as ProductID, and then select from the Default Image drop-down list, a column such as ThumbNailPhoto.

    Setting table behavior

  9. Select OK.

See Also

Power Query for Excel Help

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!

×