Chiclet slicers Data

[Anonymous]

Hi,

I have created a SQL table with a column called image which uses the 'image' data type. I create a data set for it in the query editor and the column appears as Binary, but it doesn't import in to the desktop.

Is the sql data type incompatible does it have to be something different and what should the type be in the query editor?

Thanks

[ankitpatira]

@Anonymous You should be able to change Data Type to Binary, see below image.

[Anonymous]

The top half of the screen shot shows the column in the query editor and it is already binary. the image column is not appearing in the data set.

[v-sihou-msft]

@Anonymous

Currently, Power BI Desktop doesn't support rendering either Binary Images or Images from URLs. But they can be displayed on Power BI Service. Please refer to threads below:

http://community.powerbi.com/t5/Service/How-to-Include-images-in-reports-from-folder-or-url-or-binary/m-p/2738#M771

http://community.powerbi.com/t5/Desktop/Images-binary-in-Power-BI-Desktop/m-p/1264#M214

Regards,

[Anonymous]

Sounds like it is not supported in the current version and you can only use images from URL or static images. Which unfortunaely is no help.