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.
Procedure
-
Load your data to the Data Model. For more information, see Create a Data Model in Excel.
-
Select Power Pivot > Manage.
-
Select File > Switch to Advanced Mode.
-
Select Advanced > Table Properties.
-
To enable a column containing binary data, in the Table Properties grid, select a Binary Data column, such as ThumbNailPhoto.
-
Select File > Save.
-
Select Advanced > Table Behavior.
-
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.
-
Select OK.