Forum Discussion

mjfulke's avatar
mjfulke
Microsoft Employee
8 years ago
Solved

How to use Images Stored in a SQL Server Table with Power BI

 Power BI has several options to display images in a report or dashboard but they mostly require that the image is a url to a publicly accessible website.    What I'll show you in this post is a way ...
Tips and Tricks
admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Hi guys,

 

Does anyone ever try or know how to do it with Direct Query ?

 

I tried with import and it's works, but when it is comes to Direct Query since it needs change data type on the column, it is not allowed unless I changed it to Import.

 

Anyone know how ?

 

Thanks

 

MNeish's avatar
MNeish
New Member
6 years ago

admin_xlsior I am not sure if you are still having this problem but what I found is I just created a Veiw within my SQL DB and used Json to convert the images from bianary to Base64Jpeg. The you would just pull the images from the view you created, but I am having a problem with the images being to large for Power BI to render them. 

 

CREATE VIEW TNIPIC_VIEW AS
SELECT BACK
FROM OPENJSON(
(
SELECT CUSTOMER_ID, BACK, CHECKED_IN
FROM (SELECT DBO.YOUR DATABASE AS BACK) T
FOR JSON AUTO
)
)WITH (BACK VARCHAR(MAX))