Problem loading SQL database with image column

pmartin28 · ‎09-26-2023

Hello,

I'm having problems importing a SQL query. I've already imported this database before without problems, but now when I navigate to that SQL table, this error appears:

"Explicit conversion from data type image to nvarchar(max) is not allowed

Details:

DataSourceKind=SQL

DataSourcePath=XXXXXX

Message=Explicit conversion from data type image to nvarchar(max) is not allowed.

ErrorCode=2146232060

Number=529

Class=16".

I have not done any transformation of that data column, I've only connected Power BI to that table. In this table there is a type "image" column. If I create a SQL view without this column, the query connects succesful. But I need this column and to be able to connect correctly to all the SQL tables, regardless of the type of columns there are (I didn't have any problems before).

Thanks a lot,

Best regards.

Captura de pantalla 2023-09-26 110205.png

lbendlin · ‎09-30-2023

But I need this column

what are you planning to do with it?

pmartin28 · ‎10-03-2023

I need to put this image in a tooltip. Anyway, if I connect the same SQL table to Power Query in Excel, the error doesn't appears, the connection is succesful. I don't understand why Power BI doesn't do the query as the same way.

Thanks.

lbendlin · ‎10-03-2023

In Power BI you need to Base64 encode your image data.

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/

pmartin28 · ‎10-05-2023

Okay, I'll look into it. Anyway, the issue is that before, I connected to that database table and in the image field I would see 'Binary' and could work with the query. Now, it gives an error in the preview and I can't work with the table. I have to make the connection in Power Query for Excel, remove the 'Image' column, copy the advanced query code, and paste it into Power BI. I didn't have to do all this before.